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
Don’t print page header and footer on first and last pages of a report
 
  1. Open the 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. Double-click the report selector (report selector: The box where the rulers meet in the upper-left corner of a report in Design view. Use the box to perform report-level operations, such as selecting the report.) to open the property sheet.
  3. Set the PageHeader or PageFooter property to one of the following settings:

    All Pages    (Default) Prints the page header (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.) or footer (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.) on all pages.

    Not With Rpt Hdr    Doesn't print the page header or footer on the page that has the report header (report header: A report section that is used to place information (such as a title, date, or report introduction) at the beginning of a report.).

    Not With Rpt Ftr    Doesn't print the page header or footer on the page that has the report footer (report footer: A report section that is used to place information that normally appears at the bottom of the page, such as page numbers, dates, and sums.).

    Not With Rpt Hdr/Ftr    Doesn't print the page header or footer on a page that has either a report header or footer.

Note  When you set the PageHeader property to Not With Rpt Ftr or Not With Rpt Hdr/Ftr, Microsoft Access prints the report footer on a new page.

advertisement