How to Add Conditional Page Breaks MS Access
- George Apostolov
- 05 Sep 2025
Guide
Open the database containing your report.
In the 'Form Design' tab, find the 'Controls' group and select the 'Page Break' control.
Click on the desired location in your report to place the page break.
Open the 'Property Sheet' by clicking on the 'Form Design' tab and selecting 'Property Sheet'.
Select the 'Event' tab in the Property Sheet.
In the 'On Format' event of the section, click the "..." button to open the 'VBA editor'.
Add code to show or hide the page break conditionally.
Save your changes by clicking the save icon.
Create your first interactive demo in minutes
No credit card required • Start building today
