start new page when group starts a new letter

  • Thread starter Thread starter Jim F
  • Start date Start date
J

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
 
Jim said:
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.
Click to expand...

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.
 
Back
Top