In Access, force groups to print on different pages

[Guest]

How do I force groups to print on different pages?

 

[Marshall Barton]

How do I force groups to print on different pages?

Set the group header section's ForceNewPage property to
Before Section.

 

[Nhmiller]

How do I force groups to print on different pages?

Set the group header section's ForceNewPage property to
Before Section.

Is there a way to force a group to the top of the next page only if the entire
group will not fit at the bottom of the current page? And is there a way to
split the group between the two pages, part at the bottom of one page, and part
at the top of the next page, and have the group label print with "(continued)"
after it?

Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com

 

[Marshall Barton]

Is there a way to force a group to the top of the next page only if the entire
group will not fit at the bottom of the current page? And is there a way to
split the group between the two pages, part at the bottom of one page, and part
at the top of the next page, and have the group label print with "(continued)"
after it?

The group (Sorting and Grouping) also has a KeepTogether
property.

Group header sections have the RepeatSection property so you
can make it appear on each page the group spans. To get the
word "continued", add a label control (named lblCont) to the
group header.

Now add a text box (named txtLineCount) to the detail
section. Set its Control source expression to =1 and its
RunningSum property to Over Group.

Then use code in the group header's Format event to make the
label visible or not:

Me.lblCont.Visible = (Me.txtLineCount > 1)