how do i show only 1 record per page

chefdaveross

Registered User.
Local time
Yesterday, 20:39
Joined
Aug 31, 2007
Messages
81
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
 
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.
 
I'm a newbie to Access. Can you explain in detail?
 
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
 

Users who are viewing this thread

Back
Top Bottom