You can force a page break in a report if a condition is met by setting the Visible property of a page break control in a macro or an event procedure.
Use a macro to force a page break in a report if a condition is met
Use Visual Basic for Applications to force a page break in a report if a condition is met