How can I force a new page, or create a page break in a report to split a report up in Access 2007? To force a new page in your report can be before or after sections. What clarifies a section? Sections include page header or custom header like for example say a report on books and adding a Book Title header. To expand upon the Book example, let say for every Book Title sold you want to break in your report. So for every Book Title sold you'll have a list of clients below each Book Title. This way every time you have a Book Title you can force the next Book Title and the clients who purchased that title onto a new page. To help clarify or make your reports more distinctive

Purchase the training video and you can see this in action for yourself!