setting "top" of report footer by VBA?

  • Thread starter Thread starter EVPLS
  • Start date Start date
E

EVPLS

Hello,

I need to print a report with the report footer always appearing at the
bottom of the last page: The usable space on a page is 11,329 twips (19.98
cm), the report footer height is 6,611 twips (11.66 cm). That is, I need the
report footer to start at 4,718 twips from the top of the page. The report
footer contains labels with company name and address as well as the "legal
stuff".

I cannot use the page footer for an "if me.page = me.pages" construction
because the page footer contains labels and text boxes with document number,
revision and release date as well as document title information, adding up to
a height of 1,050 twips (1.85 cm) and the page footer height cannot be
changed. Setting the page footer height at 6,611 twips (to be able to use an
"if me.page = me.pages" condition would be a waste of space on all but the
last pages.

Has anyone out there got an idea? Thank you very much for your help.
 
EVPLS,
If I understand correctly...
Can't you just do a Page Break in the Report Footer?
Your Report Footer should be sized to print your data 3.27"
from the top of the last page.


ReportFooter-----------------------
Page Break




Your data down here...

--
hth
Al Campagna
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Back
Top