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(acGr oupLevel1Header ).ForceNewPage = 1

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

acGroupLevel1He ader = 5
acGroupLevel1Fo oter = 6
acGroupLevel2He ader = 7
acGroupLevel2Fo oter = 8

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

--
Wayne Morgan
MS Access MVP
"Kat" <ka**********@c omcast.net> wrote in message
news:62******** *************** ***@posting.goo gle.com...

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