Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. ACC2000: How to Print Only One Record on Each Page for a Report

ACC2000: How to Print Only One Record on Each Page for a Report

View products that this article applies to.

This article was previously published under Q314628
Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

↑ Back to the top

Summary

This article explains how to print only one record on a page on a report.

↑ Back to the top

More information

The following example illustrates the use of the Force New Page section property of a report to break the page between records.
  1. Create the report by using the Report Wizard:
    1. In the Database window, click Reports under Objects, and then click New.
    2. In the New Report dialog box, click Report Wizard, click the table or query that contains the data for the report in the Choose the table or query where the object's data comes from box, and then click OK.
    3. To create the report, follow the instructions that the Report Wizard provides.
  2. In the Database window, right-click the newly created report, and then click Design View.
  3. Right-click the Detail section, and then click Properties.
  4. On the Format tab, set the following properties:
    Force New Page: Before Section
    Keep Together: No
  5. Save the changes, and then preview the report.
Note that as you scroll through the pages of the report, the page breaks after each record of data.

↑ Back to the top

Keywords: KB314628, kbprint, kbhowto

↑ Back to the top

Article Info
Article ID : 314628
Revision : 2
Created on : 6/29/2004
Published on : 6/29/2004
Exists online : False
Views : 249