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