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-32
Completing the Group Header section and forcing a page break before the Category
Header section
336
Access Building Blocks Part I
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 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.
The four Force New Page property settings are listed here:
n None: No forced page break (the default)
n Before Section: Starts printing the current section at the top of a new page every time
there is a new group
n After Section: Starts printing the next section at the top of a new page every time there is
a new group
n Before & After: Combines the effects of Before Section and After Section
To create the report you want, force a page break before the Category group with the Force New
Page property in the Category header:
1.
Pages:
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770