Can I suppress Page 1 of an Access report?

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!
LVL 2
Jarred MeyerProduction ManagerAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor President / OwnerCommented:
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.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Just set all the other section's visible property to false or set all their heights to 0"

Jim.
0
 
Jarred MeyerProduction ManagerAuthor 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?
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<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.
0
 
Jarred MeyerProduction ManagerAuthor Commented:
Thanks Jim.. That did the trick for that. Just needed to set KeepTogether property to false.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.