Keeping things together on report

  • Thread starter Thread starter Jim Burke in Novi
  • Start date Start date
J

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.
 
Jim said:
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?
Click to expand...


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.
 
Thanks, you both had the solutions, worked like a charm.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Alternating colours in Access 2007 report 3
Adding a back page to every report page? 1
page header on second page of invoice. 3
Problem with programming for 3 labels per page 2
Prevent skip to new page after last page prints 3
subtotal group records in Access 2007 3
Gouping In Sub Reports Leaving Windowed Headings 2
Control detail section height size in Ac2007 2

Back
Top