In Access, force groups to print on different pages

  • Thread starter Thread starter Guest
  • Start date Start date
How do I force groups to print on different pages?
Set the group header section's ForceNewPage property to
Before Section.
Click to expand...

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


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