PRB: Report Property PageFooter Set to "Not With Rpt Ftr"

Article ID: Q113297
Creation Date: 31-MAR-1994
Revision Date: 19-SEP-1996

The information in this article applies to:

Microsoft Access versions 1.0 and 1.1

SYMPTOMS

When you set a report's PageFooter property to Not With Rpt Ftr, the page footer still prints on the last page of the report with the report footer.

CAUSE

The PageFooter property, if set to Not With Rpt Ftr, was designed to not print the page footer if the report footer is the first section printed on the report.

Note that the PageHeader property works similarly. The PageHeader property, if set to Not With Rpt Ftr, was designed to not print the page header if the report footer is the first section printed on the page.

RESOLUTION

Setting the report's PageFooter property to Not With Rpt Ftr alone does not prevent the page footer from printing with the report footer.

To keep the page footer from printing with the report footer, set the report footer's ForceNewPage property to Before Section. Alternatively, if the PageHeader property is set to Not With Rpt Ftr, the report footer section is forced to a new page and no page footer section prints.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

 1. Open the sample database NWIND.MDB.

 2. Open the Alphabetical List Of Products report in Design view.

 3. From the View menu, choose Properties.

 4. Set the report's PageFooter property to Not With Rpt Ftr.

 5. Add a label control with the text "My Report Ftr" to the report
    footer section.

 6. From the File menu, choose Print Preview.

 7. Move to the last page of the report. Note that both the report footer
    and the page footer (page number) are printed.

 8. Choose the Cancel button on the toolbar.

 9. Change the report footer property ForceNewPage to Before Section.

From the File menu, choose Print Preview. Move to the last page
    of the report. Note that the report footer is printed on a new
    page, without the page footer.

REFERENCES

Microsoft Access "User's Guide," version 1.0, Chapter 18, "Designing Reports," page 445

Microsoft Access "User's Guide," version 1.1, Chapter 18, "Designing Reports," page 449

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.