You are currently offline, waiting for your internet to reconnect

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

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).

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.
prb per individual

Article ID: 314628 - Last Review: 10/25/2013 22:42:00 - Revision: 3.0

Microsoft Access 2000 Standard Edition

  • kbnosurvey kbarchive kbhowto kbprint KB314628