Group footer starting on new page

  • Thread starter Thread starter PayeDoc
  • Start date Start date
P

PayeDoc

Hello All

As well as needing to stop the page header/footer printing on odd pages (my
previous post), I also have a problem with a group footer. Initially the
report was fine - page header, group header, detail section, group footer
and page footer all printing on the same page (the data is such that the
detail section will never have more than 5 records, each showing on one row,
so everything fits nicely on one page). Now, I need to add some more
textboxes/labels to the group footer (about 6 vertical inches worth), and
all these new textboxes/labels must be on page 2 - so I used the page-break
tool to separate the original group-footer textboxes/labels from the new
ones. The problem is that the addition of the new textboxes/labels has
caused the original textboxes/labels to be printed on a new page - and the
new textboxes/labels are printed on page 3 (presumably because of the
page-break tool) !

I can't understand why the additional textboxes/labels have had any effect
on the position of the original ones, especially as they are separated by
the page-break tool. If I remove the page-break tool I still get the
original textboxes/labels starting on page 2 - along with about half the new
textboxes/labels!!

Is this a bug?

Hope someone can help.
Many thanks
Leslie Isaacs
 
PayeDoc said:
As well as needing to stop the page header/footer printing on odd pages (my
previous post), I also have a problem with a group footer. Initially the
report was fine - page header, group header, detail section, group footer
and page footer all printing on the same page (the data is such that the
detail section will never have more than 5 records, each showing on one row,
so everything fits nicely on one page). Now, I need to add some more
textboxes/labels to the group footer (about 6 vertical inches worth), and
all these new textboxes/labels must be on page 2 - so I used the page-break
tool to separate the original group-footer textboxes/labels from the new
ones. The problem is that the addition of the new textboxes/labels has
caused the original textboxes/labels to be printed on a new page - and the
new textboxes/labels are printed on page 3 (presumably because of the
page-break tool) !

I can't understand why the additional textboxes/labels have had any effect
on the position of the original ones, especially as they are separated by
the page-break tool. If I remove the page-break tool I still get the
original textboxes/labels starting on page 2 - along with about half the new
textboxes/labels!!
Click to expand...

Check the detail section's ForceNewPage and KeepTogether
properties.
 
Hi Marshall

It's not that: Force New Page is set to None, and Keep Together is set to
Yes - on the detail section and also the group footer section.

What else can it be?

Hope you can help.
Thanks again
Les
 
PayeDoc said:
It's not that: Force New Page is set to None, and Keep Together is set to
Yes - on the detail section and also the group footer section.
Click to expand...


Using KeepTogether Yes doesn't make sense if you also have a
page break control. Try changing it to No.
 
Marshall

I did wonder about that, and thought it must just be a matter of the page
break control taking priority over the Keep Together setting. In fact I get
the same behaviour either way!

Any other ideas what's going wrong here?

Thanks again for your help.

Les
(at home now, hence this might not come from 'Payedoc')
 
Please check the ForceNewPage and KeepTogether properties of
the group footer too.

If that doesn't help, the only other straw I can try to
grasp is maybe you inadvertantly added an extra page break
control at the bottom of the detail or at the top of the
group footer. These can be difficult to see so you may need
to use Tab and Shift Tab to move through all the controls in
each section.
 
Marshal

Cracked it!!

The ForceNewPage properties of the group footer was set to None, and the
KeepTogether was set to Whole Group .... in the report's Sorting and
Grouping dialogue window. I then noticed the Keep Together setting in the
group footer properties dialogue window, changed it from Yes to No, and Hey
Presto!

Many thanks for your help
Les



Marshall Barton said:
Please check the ForceNewPage and KeepTogether properties of
the group footer too.

If that doesn't help, the only other straw I can try to
grasp is maybe you inadvertantly added an extra page break
control at the bottom of the detail or at the top of the
group footer. These can be difficult to see so you may need
to use Tab and Shift Tab to move through all the controls in
each section.
--
Marsh
MVP [MS Access]


Leslie said:
I did wonder about that, and thought it must just be a matter of the page
break control taking priority over the Keep Together setting. In fact I get
the same behaviour either way!


"Marshall Barton" wrote
Click to expand...
Click to expand...
 
Back
Top