PageFooter Positioning

[Dwade]

I have a report and when the page is not Full, ie. Query returns a short list
of 4-8 items, the resulting report while accurate looks off because the page
footer prints immediately after the detail section.

If the report rolls to two pages the first page footer will print fine, the
second page will be off if it is not a full page.

I want the report footer to print one or two lines above the bottom margin.
In other words I want to force the page footer to print at the bottom of the
page in a set position. 8.2" if printing landscape on 8.5 x 11 paper.

It seems odd that one can set header and footers in Word or Excel to print
exactly where one wishes but not in Access.

 

[Duane Hookom]

The Page Footer always prints at the bottom of the page. I think you are
referring to the Report Footer which prints immediately after the final
detail section.

 

[Dwade]

No, I do mean the page footer.

I can scan the report to pdf and do a print screen of the report set up to
pdf but I don't know how to post attachments here, or if it is even possible.

Where I wrote... "I want the report footer" should read "I want the page
footer... "

 

[Duane Hookom]

I have never seen a report where the Page Header or Page Footer didn't print
at the very top or very bottom of a page. If you are finding something
different, try create a new report to see if other reports behave in the same
manner.

 

[Dwade]

I deleted the report and several other variations of it. When I re-created it
the problem re-occured.

I again deleted the report and compacted and repaired the database. Then
created the reports and so far it appears to be fine.

Thanks to everyone who looked for an answer.

 

[Michael J. Strickland]

I have a report and when the page is not Full, ie. Query returns a
short list
of 4-8 items, the resulting report while accurate looks off because
the page
footer prints immediately after the detail section.

If the report rolls to two pages the first page footer will print
fine, the
second page will be off if it is not a full page.

I want the report footer to print one or two lines above the bottom
margin.
In other words I want to force the page footer to print at the bottom
of the
page in a set position. 8.2" if printing landscape on 8.5 x 11 paper.

It seems odd that one can set header and footers in Word or Excel to
print
exactly where one wishes but not in Access.

I believe the page header, detail, and footer are really just 3 sections
of your report page. The header section prints first, then the detail,
then the footer. You set the location of the footer section by changing
the size of the detail section. If you Rt. Click on the footer section
border you will notice that it has no .Top property, just a .Height
property.

So, to get a footer to print at 8.2", make sure the sum of your header
and detail sections (+ report top margin) is 8.2".

--