How to Add Conditional Page Breaks MS Access

‍

‍

Adding conditional page breaks in Microsoft Access can help you create reports that are formatted cleanly and easier to read. Here’s how you can do it:

‍

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 on 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 code to show or hide the page break conditionally.
8. Save your changes by clicking the save icon.