Formatting Footer Issue

[Green Biro]

I have two parts to the footer of a report. One is a summary and one is a
'customer notes' section which is just a few lines for the customer to write
in. I had inserted a page break between the two as the summary is obviously
related to the main body of the report whereas the notes could appear on a
separate page.

Now the customer is asking if the note lines can be included on the same
page <whenever they fit> ie he doesn't want his notes page split but
equally he doesn't want them on a new page when they would have fitted at
the end of the report without using another piece of paper.

It feels like I need two 'sections' in my report footer, the second with
'Keep Together' set to True but that functionality doesn't seem to exist in
Access. Is there any other way I can detect if there's enough page space
remaining to insert the customer notes part.

Thanks in advance.

GB

 

[Arvin Meyer [MVP]]

You cannot split a report footer, but you do have 2 options:

1. Page footer which appears on every page.
2. Group footer which appears at the end of each group.

By slightly redesigning your report, either of those solutions should work.

 

[asd123]

aaaaa

 

[Green Biro]

Thanks. That worked a treat.

GB

You have to be a bit sneaky.

1. Add an extra computed column to the report's underlying query:

TopGroup:0

2. Use the TopGroup column as the report's first group level. As its
value
is the constant zero, the group will cover the whole report. Give it a
group
footer.

3. Instead of including the summary controls in the report footer put
them
in the TopGroup group footer, which will only print once at the end of the
report.

4. Include your Notes lines in the report footer. Make sure the report
footer's KeepTogether property is True.

If there is no room below the TopGroup group footer (which appears as a
pseudo report footer) the real report footer with the Notes lines will
move
to another page; if there is room, however, it will print on the same
page.

Ken Sheridan
Stafford, England