# How to Add Conditional Page Breaks MS Access

> 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.

Canonical: https://livedemo.ai/tutorials/how-to-add-conditional-page-breaks-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a2d0aa98365d0865706b2/preview?step=1

## 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 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.