Keeping things together on report

[Jim Burke in Novi]

Two questions:

I have a report set up with two fields specified in Sorting and Grouping. I
have a group header and footer specified for both. When it gets to a new
'group', I want to always keep the header, detail section and footer all
together. Right now, when it gets near the bottom of the page it will print a
group header there, then print the detail section and footer on the next
page. Can I tell Access to print the header on a new page if and only if the
detail and footer will not fit along with the header?

In a similar vein, I have a report footer. I have my 'outer' group footer
set to Force New Page - After Section, which is what I want with the
exception of the end of the report. Is there a way for me to detect that I am
on the last value of the field specified for that group so that it won't go
to a new page before printing the report footer?

Any help is appreciated. Thanks.

 

[Marshall Barton]

Two questions:

I have a report set up with two fields specified in Sorting and Grouping. I
have a group header and footer specified for both. When it gets to a new
'group', I want to always keep the header, detail section and footer all
together. Right now, when it gets near the bottom of the page it will print a
group header there, then print the detail section and footer on the next
page. Can I tell Access to print the header on a new page if and only if the
detail and footer will not fit along with the header?

In a similar vein, I have a report footer. I have my 'outer' group footer
set to Force New Page - After Section, which is what I want with the
exception of the end of the report. Is there a way for me to detect that I am
on the last value of the field specified for that group so that it won't go
to a new page before printing the report footer?

You should be able to do that by setting the **group**
KeepTogether property (in the Sorting and Grouping window).

Instead of using ForceNewPage on the group footer, try
setting it to Before section on the group header.

 

[Jim Burke in Novi]

Thanks, you both had the solutions, worked like a charm.