How to Add Conditional Page Breaks MS Access

Quick summary

Conditional page breaks in MS Access let you control where pages split in a report based on custom logic written in VBA. By attaching code to a section's On Format event, you can programmatically show or hide a page break depending on your data conditions.

Steps

1. Open the database containing your report.
2. In the Form Design tab, find the Controls group and select the Page Break control.
3. Click on the desired location in your report to place the page break.
4. Open the Property Sheet by clicking the Form Design tab and selecting Property Sheet.
5. Select the Event tab in the Property Sheet.
6. In the On Format event of the section, click the "..." button to open the VBA editor.
7. Add VBA code to show or hide the page break conditionally.
8. Save your changes by clicking the save icon.