Force new page when 1st character in field changes

[Perplexed]

I would like to force a new page when the 1st letter of a field changes,
i.e., A to B in order to insert Alphabetica Index Tabs.

Thanks!

 

[John Spencer]

Select Sorting and Grouping from the view menu
Group by the field
Set Group on to Prefix Characters
Set Interval to 1
Set Group Header or Group footer to Yes (or do both)
Close the dialog
In the Group Header Set Force New Page property to Before Section or in
the Group Footer Set Force New Page property to After Section or before
section.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Perplexed]

Thanks John,
I had tried this and I get the forced page break but the problem with it is
it stops all the fields from being grouped in alphabetical order i.e.:

Agenda
Audit
Advertising
Audit
Article
Agenda

I have the keep together by group on and have tried all the selections but
it doesn't resolve the problem. Any ideas?

 

[John Spencer MVP]

You need to add another sort level that sorts by field.

So you group by the first letter and then sort by the entire field.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Perplexed]

Works like a charm! Thanks so much -- you're terrific!