Orphan Footers

[Tom]

Hi all:

How do I prevent an orphan footer in a report. Basically, I am trying
to sum a bunch of values in a group footer. Occasionally there is a
bad page break and the detail records are all on one page and ONLY the
footer is on the next page.

I'd like to force at least one of the detail records onto the same
page as the footer.

Thanks

 

[Frank H]

The property sheet of the footer section has a property call Keep together.
Turn that on.

 

[Tom]

Frank:

Thanks for the tip - I had thought (mistakenly) that only applied to
headers. Works fine* if I set the section to yes and grouplevel to
"Whole Group" (I had it set on "With First Detail").

*Except in the not very common occurance that there is exactly the
right number of detail records such that the header and detail fill
the page. Then the footer gets orphaned again. Ideally, there would
be an easy way of telling Access to push at least one detail record
over to the page the footer is on.

Tom