How to Add Conditional Page Breaks MS Access
- George Apostolov
How to Add Conditional Page Breaks MS Access: step-by-step 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.
Quick answer: To add conditional page breaks in MS Access, open your database report, select the Page Break control from the Form Design tab, and place it. Next, open the Property Sheet from the Form Design tab, go to the Event tab, click the On Format event ellipses to open the VBA editor, add your conditional code, and save your changes.
About this tutorial
Configure conditional page breaks in the app by placing a page break control, adding VBA code in the On Format event, and saving the report. This guide shows how to add Conditional Page Breaks MS Access in 8 steps, starting with "Open the database containing your report" and finishing with "Save your changes by clicking the save icon". The interactive demo above is a click-through copy of the real product interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to add Conditional Page Breaks MS Access?
8 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your data or settings. Once you know the flow, repeat it in your own workspace.
Create your first interactive demo in minutes
No credit card required • Start building today
