Report Footer

[Volta]

I have a report footer established in my report but the length of the
detail region dictates where on the page the report footer prints. I need
it anchored at the bottom of the page. How do I anchor the report footer to
the bottom of the page?

(Sorry to duplicate an earlier posting but I was afraid that people would
see that it had been responsed to and assume I had gotten a viable
solution...)

 

[Larry Linson]

The simple answer is, you cannot anchor it to the bottom of the page.
Offhand, I don't know of a good solution other than duplicating the
information in the Page Footer and playing with the Visible property. (I
haven't done that, so don't have specific suggestions as to exactly what to
do.)

Larry Linson
Microsoft Access MVP

 

[Volta]

Thank you for responding Mr. Linson. Have you ever used the GoToPage macro?
I am currently trying to use that to accomplish positioning the report
footer - but with no luck. I am unsuccessfully using the macro as an
"OnPrint" procedure for my report footer with the following parameters:

Page Number: (blank)
Right: 0"
Down: 6.75"

 

[Larry Linson]

Because macros have no provision for error handling I don't use them, but I
do not think "GoToPage" will allow you to position the Report Footer as you
want.

If the size of the Report Footer is not significantly larger than the size
of your Page Footer, give some thought to the solution I proposed earlier.
The VBA code is, I think, relatively simple.

Larry Linson
Microsoft Access MVP