Report Footers

[MonsterMan]

Could someone tell me how to either have a report footer appear at the base of the Page or a Page footer appear on the last page only?

 

[jimmythegeek]

Why would you need to do this?
You are trying to reverse the Footers.

It seems to me, you already have what you need. A Page Footer appears at the bottom of every page, and a Report Footer appears on the last page only.

What would the purpose be for wanting them opposite? Jim Lunde
compugeeks@hotmail.com
Custom Application Development

 

[mxcool]

Okay....so I'm new to Access (but I've done a lot of DB design going back to the DOS days...) So, Ive written an access app to sequentially allow us (architects) to write uip meeting minutes......and, in 2 sections (Old Busines - New Business) I have it working to shrink/expand as need be....we sometime may have 1 item of old business, or 20...the same with new. But in designing the report lay-out I need to generate a printed report which mimics the form lay-out of the db entry form. That may mean that for one report, it could all be on one page; the following meeting might require 3 pages, with most of the report reflecting the items of New Business. As it is now, when I print, the contents of those fields are not being constrained to the physical amount of space needed.......how can I adjust and/or control this feature?

 

[ChiTownDiva]

MonsterMan & JimmytheGeek:

MonsterMan, try writing an event procedure by going to the design view of your report and right-clicking on the Report Footer. Write your procedure for "On Format".

I can't tell you what the code is--it's on my bosses PC, but I know it worked.

The Page Footer is going to show up on every page. You probably can control that the same way--using an event procedure.

JimmytheGeek, at my company we have a report that shows the total sum of orders on every single page. If you put that text box in the Page Footer, you get that lovely little "Error#" message. So, my boss did a work around by writing a procedure that basically says "format this report footer to show up on every single page".