I don't want a group header and the bottom of the page with no Detail

[Bryce Dalley]

I'm creating a report that is approx. 5 pages. There are
about 10 group headers. I don't want a group header to be
at the bottom of the page with no detail for that
particular header, but instead the header on the top of
the next page where the detail is. In the properties for
the group header, I can force a new page before of after
the header, but that doesn't work because I want the
report shorter. Is there any way that I can tell Access
to put the group header on the next page if no detail for
that header will fit on the page?

Please help.

I'm working on access '97

 

[Marshall Barton]

I'm creating a report that is approx. 5 pages. There are
about 10 group headers. I don't want a group header to be
at the bottom of the page with no detail for that
particular header, but instead the header on the top of
the next page where the detail is. In the properties for
the group header, I can force a new page before of after
the header, but that doesn't work because I want the
report shorter. Is there any way that I can tell Access
to put the group header on the next page if no detail for
that header will fit on the page?

Set the group's KeepTogether property to With First Detail.

Note that the group properties are set in the Sorting and
Grouping window. (These are separate from the section
properties.)