start new page when group starts a new letter

[Jim F]

I have an Access 2000 report that uses Grouping. The
group criteria is manufacturers. Some groupings have few
records, so more than one manufacturer can fit on a
sinlge page. All well and good.

Is there a way to start a new page when the first letter
in the manufacturer name changes?

Ex. Manufacturers ACME, APEX, AXEL all fit on one page
with room for mfr. BALL, BIZTEL, etc. But I want to
start the manufacturers starting with "B" and each new
letter to start on a new page.

Thank you

 

[Marshall Barton]

I have an Access 2000 report that uses Grouping. The
group criteria is manufacturers. Some groupings have few
records, so more than one manufacturer can fit on a
sinlge page. All well and good.

Is there a way to start a new page when the first letter
in the manufacturer name changes?

Ex. Manufacturers ACME, APEX, AXEL all fit on one page
with room for mfr. BALL, BIZTEL, etc. But I want to
start the manufacturers starting with "B" and each new
letter to start on a new page.

Insert a group above the manufacturer's group. Group on
the expression =Left(manufacturer, 1). Then set the group
header (it can be very short) section's Force New Page
property to Before Section.

 

[Jim F.]

Marshall,

Thank you very much. Your solution works like a charm.

Jim F.