Each record in a new page

[am_sarath]

Hello,

I want to print the records, one in each page.
Let us assume, person, address,city, and so on are in the report layout.In my db i have some 10 records.
when i would like to print the report, only one person and his details should be printed on one page and the 2nd person in a new page and it follows.
How can i do this?

 

[Opengrave]

Insert a page break just beneath the text boxes in the detail section of the report. This will force a page break after each record.

 

[Graham T]

In Access 2000 you can select the Detail section and from the property sheet for this choose > Format:

Force New Page: After Section

HTH

 

[Pat Hartman]

In the report's sorting and grouping options, group by PersonId. Then in the personID group header, set the property to change page before section.

You don't actually need to place any fields in the person header unless you want to. Just drag the section closed so that it does not occupy any vertical space.