Microsoft Access 2010 Bible

Part I: Access Building Blocks

366

Figure 9.35 shows this property window and the completed report design. The Property
Sheet is opened in this figure so that you can see how the Force New Page property is
set for the Category Header section.

FIGURE 9.35

Completing the Group Header section and forcing a page break before the Category

Header section

In Figure 9.35 notice that the group header is named Category. You name a report section by

selecting the section bar (such as GroupHeader0) and provide a name for the section in the

Property Sheet.

Adding page breaks

Access enables you to force page breaks based on groups. You can also insert forced breaks within

sections, except in Page Header and Page Footer sections.

In some report designs, it’s best to have each new group begin on a different page. You can achieve

this effect easily by using the Force New Page property of a group section, which enables you to

force a page break every time the group value changes.