We help IT Professionals succeed at work.

Can I suppress Page 1 of an Access report?

Jarred Meyer
Jarred Meyer asked
on
Just curious if I can throw some VBA in the On Load event of an access report to suppress or hide page one. I have a rather unusual (so I think) report where all of my data is in the Report Footer. Because I'm using just the report footer and my data extends more than one page, I'm getting a blank first page. If there is some kind of cancel vba I can put on the report so that it will suppress the first page, that will accomplish my goal perfectly!

Thanks for the help!
Comment
Watch Question

Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:
Just set all the other section's visible property to false or set all their heights to 0"

Jim.
President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017
Commented:
Sorry, should have read that a bit better:

"Because I'm using just the report footer and my data extends more than one page,"

Make sure the footer's KeepTogether property is set to false.

Jim.
Jarred MeyerProduction Manager

Author

Commented:
Guess I should have mentioned I tried that.. I set all their visibilities to false and set the height to 0..

Do you know if it is possible to connect to my datasource for this report in VBA and keep the report unbound, then I could place all of my sumations, which are currently in the report footer in the detail section?
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:
<<Do you know if it is possible to connect to my datasource for this report in VBA and keep the report unbound, then I could place all of my sumations, which are currently in the report footer in the detail section?>>

Absolutly.

See my second comment though first.

Jim.
Jarred MeyerProduction Manager

Author

Commented:
Thanks Jim.. That did the trick for that. Just needed to set KeepTogether property to false.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.