Reports - force new page

[flaghippo]

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]

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

 

[Pat Hartman]

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]

Thank you both for your kind replies.

I will give you suggestions a try.

Flaghippo

 

[Big Pat]

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

 

[Pat Hartman]

Probably