Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Access
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
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.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Set the option to print each record, group, or section on a separate page
 

ShowFor a form or report

  1. 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.).
  2. 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 (group header: Used to place information, such as group name or group total, at the beginning of a group of records.), and set the ForceNewPage property to Before Section. Alternatively, you can set the ForceNewPage property of the group footer (group footer: Used to place information, such as group name or group total, at the end of a group of records.) 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 (page header: Used to display a title, column headings, dates, or page numbers at the top of every page in a form or report. In a form, the page header appears only when you print the form.) and footers (page footer: Used to display page summaries, dates, or page numbers at the bottom of every page in a form or report. In a form, the page footer appears only when you print the form.).

ShowFor a data access page

  1. 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.).
  2. 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.
  3. 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.

advertisement