Keep Together last record detail with group footer

[Guest]

Using Access 2000

In the same way that you can keep together with first detail on group header
- can you keep together with last detail on group footer??

Basically is there a simple way to make the group footer for a section stay
with the last record detail? What I need is if the group footer for a
section has to go on the next page, I want the last detail to go there as
well, so the group footer isn't sitting on a new page on it's own??

 

[Allen Browne]

If the sections are fixed height (i.e. without CanGrow or CanShrink), you
can:
1. Add a page break control to the top of the detail section (in the
Toolbox).

2. Toggle its Visible property in the Format event of the section, based on
the Top property of the report.

If the report's Top indicates that the record is too far down the page to
fit the Detail section + the group footer section, set the Visible property
of the page break control to True to force it onto the next page. (The
control does have a Visible property, even though the Intellisense does not
show it.)