Adding Page Breaks to Access Report

Here are the steps to add a Page Break to a report in Microsoft Access 365:
Steps:

1. Open the Report in Design View:
   • Open your database in Microsoft Access.
   • Navigate to the Navigation Pane, locate the report you want to modify, right-click it, and select Design View.
2. Access the Toolbox:
   • Ensure the Design tab is selected in the Ribbon.
   • In the Controls group, click the drop-down arrow to expand the toolbox (if it's not already visible).
3. Select the Page Break Tool:
   • Locate and click the Page Break tool (an icon that looks like two horizontal lines with a small arrow pointing to the right).
4. Insert the Page Break:
   • Click on the section of the report where you want the page break to occur. You can insert the page break in:
   • Report Header/Footer (to create a break between report sections).
   • Group Header/Footer (to start a new page for each group).
   • Detail Section (to break data within the detail rows).
5. Adjust Placement:
   • The page break appears as a small horizontal line labeled Page Break.
   • Drag it to the desired location in the report design.
6. Save the Report:
   • Click File > Save, or press Ctrl + S to save your changes.
7. Preview the Report:
   • Switch to Print Preview (found under the View button) to ensure the page break behaves as expected.

Tips:

• Page breaks work best when placed in headers or footers rather than the middle of content-heavy sections.
• You can remove a page break by clicking it and pressing Delete.

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.

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:

1. None: No forced page break (the default)
2. Before Section: Starts printing the current section at the top of a new page every time there is a new group
3. After Section: Starts printing the next section at the top of a new page every time there is a new group
4. Before & After: Combines the effects of Before Section and After Section

To force a page break before the Category group:

1. Click anywhere in the Category header, or click the Category Header bar above the section.
2. Display the Property Sheet and select Before Section in the Force New Page property's drop-down list.

Add page breaks to the Hours by Project report in the following exercise.
Adding Page Breaks - Exercise