Set the option to print each record, group, or section on a separate page

Microsoft Office Access 2003

  1. Open the form or report in Design view.
  2. Do one or more of the following:

    To print each record on a separate page, double-click the section selector of the detail section, and set the ForceNewPage property to After Section.

    To print each group on a separate page, double-click the section selector of the group header, and set the ForceNewPage property to Before Section. Alternatively, you can set the ForceNewPage property of the group footer to After Section.

    To print a section on a separate page, double-click the section selector of a section, and set its ForceNewPage property to either Before Section or Before & After.

Note  The ForceNewPage property is available for all sections except page headers and footers.

ShowFor a data access page

  1. Open a data access page in Design view.
  2. Double-click the section bar of the section that you want to print.
  3. Do one or more of the following:
    • To print each detail record on a separate page, set the PageBreakBefore or PageBreakAfter property of the header section of the lowest group level to Always.
    • To start each group on a separate page, set the PageBreakBefore property of the caption section of the corresponding group level to Always. If the group doesn't have a caption section, set the PageBreakBefore property of the header section.
    • To start a specific section— such as a record navigation section or a group footer— on a separate page, set its PageBreakBefore property to Always.

Note  Setting the PageBreakBefore and PageBreakAfter properties of a section to Always ensures that no other section will be printed on the same page as this section.