Microsoft KB Archive/314628

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

Article ID: 314628

Article Last Modified on 6/29/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.  Create the report by using the Report Wizard:  In the Database window, click Reports under Objects, and then click New. 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. To create the report, follow the instructions that the Report Wizard provides.  In the Database window, right-click the newly created report, and then click Design View.</li> Right-click the Detail section, and then click Properties.</li> On the Format tab, set the following properties:

Force New Page: Before Section

Keep Together: No

</li> Save the changes, and then preview the report.</li></ol>

Note that as you scroll through the pages of the report, the page breaks after each record of data.

Additional query words: prb per individual

Keywords: kbhowto kbprint KB314628

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.