Can't set properties in Report Open event !?!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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.
 
Back
Top