Report Footers Report Footers MonsterMan (Programmer) (OP) 30 Jan 01 15:02 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? RE: Report Footers jimmythegeek (Programmer) 30 Jan 01 17:20 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 Lundecompugeeks@hotmail.comCustom Application Development RE: Report Footers mxcool (Instructor) 31 Jan 01 08:36 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? RE: Report Footers ChiTownDiva (TechnicalUser) 16 Feb 01 10:47 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".