Reports - force new page (1 Viewer)

flaghippo

Registered User.
Local time
Today, 05:01
Joined
Jan 22, 2012
Messages
19
Hi

I would like to force a new page on a report when grouped.

I need the page filled up with as many groups as possible.
If infomation will not fit onto one page then force a new page at the bottom.

All information in the group must be together i.e. group header and details

If you have VBA code that that would be great.

Thanks.
 

Big Pat

Registered User.
Local time
Today, 12:01
Joined
Sep 29, 2004
Messages
555
You don't need VBA for this. Use the Grouping and sorting function in Report design mode and specify that you want to keep the whole group together. Select the group footer and put a page-break there. Attached jpeg shows example in Access 2003, I believe it's pretty similar in newer versions
 

Attachments

  • Grouping.jpg
    Grouping.jpg
    92.2 KB · Views: 948

Pat Hartman

Super Moderator
Staff member
Local time
Today, 08:01
Joined
Feb 19, 2002
Messages
42,970
The page break control is used to break a single section into multiple pages. It is not used to force a page break on a change in value. To do that, just change the ForceNewPage property on the group header.
 

flaghippo

Registered User.
Local time
Today, 05:01
Joined
Jan 22, 2012
Messages
19
Thank you both for your kind replies.

I will give you suggestions a try.

Flaghippo
 

Big Pat

Registered User.
Local time
Today, 12:01
Joined
Sep 29, 2004
Messages
555
The page break control is used to break a single section into multiple pages. It is not used to force a page break on a change in value. To do that, just change the ForceNewPage property on the group header.

I never knew about that one. Great tip. I wonder if that's why so many of my reports seem to have a blank page at the end
 

Users who are viewing this thread

Top Bottom