MS Access Report page/report footer issue

Posted on 2009-04-17
Medium Priority
Last Modified: 2012-05-06

I have a fairly standard access report with a report header & footer, page header & footer and a detail section.  The report is based on a query and works without problem except that if I put anything in the Report Footer section it appears immediately below the Detail section and above the Page footer and not where I would expect at the bottom of the report.

I have never come across this before - anyone have any idea what is happening?
Question by:kenabbott
  • 2
LVL 52

Accepted Solution

Gustav Brock earned 2000 total points
ID: 24168822
That is by design.
Page Header and Footer follows the pages while Report Header and Footer wrap the detail section (and its groupings if any).

LVL 46

Expert Comment

ID: 24178283
Hi Ken,
The report footer always comes at the end of the report.
If you want, you can add code that the page footer doesn't show on the last page.

LVL 52

Expert Comment

by:Gustav Brock
ID: 24178492
I think what Ken expected was that the report footer would be placed as the page footer on the last page. This is not the case, it is positioned as the last printed item of the report and is printed right below the item before whereever on the page that is placed.
This is different from the report header which (normally) is positioned at the top of page 1.


Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses
Course of the Month13 days, 11 hours left to enroll

750 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question