Is it possible to insert/remove page break FOR EACH GROUP of a report?

[Kat]

This is a new one on me...a user wants to select a report then see a
checkbox list of the "groups" to be included in the report. He wants
to turn on/off whether or not to insert a page break before each
group. Any way to do this? If so, please provide a clue as to how.
Thanks, Kat

[Wayne Morgan]

You have 4 options in the Group Header and the Group Footer to "Force New
Page"; None, Before Section, After Section, or Before and After.

To refer to the header/footer in code and set the option try something like
this in the report's Open event.

Me.Section(acGroupLevel1Header).ForceNewPage = 1

The available values are 0-3 and refer to the options in the order they're
listed above.

acGroupLevel1Header = 5
acGroupLevel1Footer = 6
acGroupLevel2Header = 7
acGroupLevel2Footer = 8

If you exceed the number of predefined constants, you can use the actual
section number instead.

--
Wayne Morgan
MS Access MVP
"Kat" <ka**********@comcast.net> wrote in message
news:62**************************@posting.google.c om...

This is a new one on me...a user wants to select a report then see a
checkbox list of the "groups" to be included in the report. He wants
to turn on/off whether or not to insert a page break before each
group. Any way to do this? If so, please provide a clue as to how.
Thanks, Kat