About this lesson
Identify Page Setup options and learn how to force a new page between sections of a second grouping.
Download this lesson’s related exercise files.Services_28_Start Page Breaks, and Page Setup.accdb
1.7 MB Services_28_Page Breaks, and Page Setup.accdb
Page Breaks and Page Setup, ForceNewPage with VBA
Force New Page
Force New Page can be set for Group sections on the Property Sheet. It can be found on the Format and All tabs of the Property sheet.
Force New Page Help
Page Setup – Page options
Page Setup Ribbon
Page Setup – Print options
Force New Page Between Second Group Sections
- To Force a New Page between sections of a second grouping, create code for the Format event of the second group footer to force a new page before the next group.
- Create code for the first group header to not break the page before the next second group header so the first second group section stays on the same page as the first group section.
Lesson notes are only available for subscribers.