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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

canshrink report header 6
Using VBA to hide a report's detail section? 1
Detail section's Height property does not alter when shrinks / gro 2
making an empty (null) field disappear from a report 3
Eliminate blank lines 2
Formatting Report based on actual control attributes 1
unwanted control duplication 2
Shrink when not visible (not when null) 2

Back
Top