View Full Version : how do i show only 1 record per page


chefdaveross
09-05-2007, 05:01 PM
I would like to show only 1 record in my report per page and have a different page for each item in my recipie database.
Looked around in the report properties and couldnt find that option

Pat Hartman
09-06-2007, 08:22 PM
Open the sorting and grouping dialog and add a group. In the group header properties, you can set the property to force a page change for each record.

SUN
10-13-2007, 02:42 AM
I'm a newbie to Access. Can you explain in detail?

coyote
10-13-2007, 03:53 AM
Open your Report in design view
Go to View-Grouping and Sorting
On the dialog form that opens Select the field you want to sort and also select the sorting order.
On the group header select Yes
On the group footer select Yes
Group on - Each Value
Keep Together Yes
Close the form and view the changes in your report design.
right Click on the group footer and go to properties.
On the Format Tab go to Force New Page . Select (After Section) from the drop down.
Save your changes and you are done.

Nb. This question has been answered before.Check the previous posts