Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Report Footers

Report Footers

Report Footers

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

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
Custom Application Development

RE: Report Footers

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

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".

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close