Orphaned group footer

[KADL]

I see how to prevent a group header from displaying when there is no room for
a detail line.

I need to prevent a footer from displaying alone on the next page. Is there
a way to save the last detail line for that next page when there is no room
for the footer?

Thanks!

 

[fredg]

I see how to prevent a group header from displaying when there is no room for
a detail line.

I need to prevent a footer from displaying alone on the next page. Is there
a way to save the last detail line for that next page when there is no room
for the footer?

Thanks!

Set the Group Header Keep Together property to either Whole Group or
With First Detail, whichever you find best. It's in the Report's
Sorting and Grouping dialog.
Also look at the Group Header and Group Footer Keep Together property
(on the Group Header/Footer Format tab on the Property sheet).
Some of these Keep Together settings are mutually exclusive, so read
Access Help for more information.

 

[Marshall Barton]

I see how to prevent a group header from displaying when there is no room for
a detail line.

I need to prevent a footer from displaying alone on the next page. Is there
a way to save the last detail line for that next page when there is no room
for the footer?

Only if the detail and group footer sections can not grow.

If you know the size of those sections, then you can compare
the last detail's Report.Top value to the position on the
page. If it's too far down the page for both sections to
fit, make a page break control at the top edge of the detail
visible.

 

[Jonesey]

I have a similar dilemma. The detail CAN shrink and grow to various lengths,
but I'd like to be able to carry over at least some detail to the footer at
the end of the report (a group footer). Is there a way for my report to put
some detail on the next page along with the header and footer that I'm trying
to "pad out"

Also I'm having some problems getting the "Continued" line to work when the
detail JUST fills page 1 of the report. I'm using the group footer and an IIF
[Page]>1 statement. It seems to work fine when there's a clear break of
detail, but when the detail ends on page 1 and causes the footer to break to
the next page then I miss the "Continued" line on page 1 and also the
"Continued from" line on page 2, which is coded in the Page Header as follows:

IIf([Page]=1,"",IIf([Page]<>2,"Continued from previous page"))

I'd appreciate any help.

 

[Marshall Barton]

Not that I can figure out. The problem is that without
hnowing the height of the sections, there is no way I can
think of to determine when to skip to the next page. Note
that the can grow height of a section is not available until
the Print event, but the Print event is too late to make
changes to the section's layout.

I'm not sure how you can use Page for displaying
"Continued..." in the general case. If your situation is
such that using Page is adequate, I think your IIf is
incorrect and recommend that you try using:

In the Page Footer:
=IIf([Page]=1,"Continued on next page","")

and in the Page Header
=IIf([Page]=1,"","Continued from previous page")
--
Marsh
MVP [MS Access]

I have a similar dilemma. The detail CAN shrink and grow to various lengths,
but I'd like to be able to carry over at least some detail to the footer at
the end of the report (a group footer). Is there a way for my report to put
some detail on the next page along with the header and footer that I'm trying
to "pad out"

Also I'm having some problems getting the "Continued" line to work when the
detail JUST fills page 1 of the report. I'm using the group footer and an IIF
[Page]>1 statement. It seems to work fine when there's a clear break of
detail, but when the detail ends on page 1 and causes the footer to break to
the next page then I miss the "Continued" line on page 1 and also the
"Continued from" line on page 2, which is coded in the Page Header as follows:

IIf([Page]=1,"",IIf([Page]<>2,"Continued from previous page"))

I'd appreciate any help.

Only if the detail and group footer sections can not grow.

If you know the size of those sections, then you can compare
the last detail's Report.Top value to the position on the
page. If it's too far down the page for both sections to
fit, make a page break control at the top edge of the detail
visible.