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

Article translations Article translations
Article ID: 314628 - View products that this article applies to.
This article was previously published under Q314628
This article has been archived. It is offered "as is" and will no longer be updated.
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).

Expand all | Collapse all


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.


Article ID: 314628 - Last Review: October 25, 2013 - Revision: 3.0
Applies to
  • Microsoft Access 2000 Standard Edition
kbnosurvey kbarchive kbhowto kbprint KB314628

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from