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


The information in this article applies to:

  • Microsoft Access 2000
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).

SUMMARY

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

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.
Modification Type:MajorLast Reviewed:6/29/2004
Keywords:kbhowto kbprint KB314628
©2004 Microsoft Corporation. All rights reserved.