| | Product Information Help and How-to Training Templates Support and Feedback Technical Resources Additional Resources | Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.
Set the option to print each record, group, or section on a separate page
For a form or report
- Open the form or report in Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.).
- Do one or more of the following:
To print each record on a separate page, double-click the section selector (section selector: The box on the left side of a section bar when an object is open in Design view. Use the box to perform section-level operations, such as selecting the section.) of the detail section (detail section: Used to contain the main body of a form or report. This section usually contains controls bound to the fields in the record source but can also contain unbound controls, such as labels that identify a field's contents.), 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.
For a data access page
- Open a data access page in Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.).
- Double-click the section bar (section bar: The horizontal bar above a data access page section in Design view. The section bar displays the type and name of the section. Use it to access the section's property sheet.) of the section that you want to print.
- Do one or more of the following:
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.
|