Since reports are designed to print, Access provides you with the flexibility to add page breaks into the report design.
Add a page break by clicking the Page Break button
in the toolbox and then clicking the report design where you want to insert the page break.
Consider carefully where in the design to put the page break. If you put a page break in the Detail section you will end up with a page for every record.
That is not usually what you want! It usually makes sense to put a page break at the end of one of the Footer sections.
Probably one of the field footer sections (such as Company Footer or Project Description Footer). This way your report will start a new page after every grouping of data.
Visit the module wrap-up to review the terms and concepts covered in this module.
Adding page breaks
Access enables you to force page breaks based on groups. You can also insert forced breaks within sections, except in Page Header and Page Footer sections.
In some report designs, it isbest to have each new group begin on a different page. You can achieve this effect easily by using the Force New Page property of a group section, which
enables you to force a page break every time the group value changes.
The four Force New Page property settings are:
None: No forced page break (the default)
Before Section: Starts printing the current section at the top of a new page every time there is a new group
After Section: Starts printing the next section at the top of a new page every time there is a new group
Before & After: Combines the effects of Before Section and After Section
To force a page break before the Category group:
Click anywhere in the Category header, or click the Category Header bar above the section.
Display the Property Sheet and select Before Section in the Force New Page property's drop-down list.