I need to set canshrink and visible properties of report sections. I did this in the report open event and Access gave an error. Can I do this? How else can I suppress a section when the data is inapplicable.
You use the section's Format event, not the Open event:
For example....
In the Page Footer's Format event
If [Page] = [Pages] then
Cancel = True
End If
The above will cancel that section only on the last page of the
report.
HOWEVER, the Can Shrink property can only be set in Design View, not
when the report is running.
