By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,378 Members | 3,020 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,378 IT Pros & Developers. It's quick & easy.

page break on first letter of LastName

P: n/a
How do I get an Access report to start a new page when the first
letter of LastName changes?
Thanks
Robert
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
In report design view, open the Sorting And Grouping box (view menu).

In the dialog, select the LastName field.

In the lower pane of the dialog, set these properties:
Group Header: Yes
Group On: Prefix Characters
Group Interval: 1
Close the dialog.

Right-click the new group header, and choose Properties.
On the Format tab of the Properties box, set:
Force New Page Before Section

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Robert Schoenert" <rs********@mindspring.com> wrote in message
news:k4********************************@4ax.com...
How do I get an Access report to start a new page when the first
letter of LastName changes?
Thanks
Robert

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.