conditional report page footer

[Guest]

I have a report that I want to control the page footer such that it is NEVER
printed on the last page of the report. If the report is only one page long
(the last page is also the first page) the page footer won't be printed.

Suggestions?

Thanks.

 

[fredg]

I have a report that I want to control the page footer such that it is NEVER
printed on the last page of the report. If the report is only one page long
(the last page is also the first page) the page footer won't be printed.

Suggestions?

Thanks.

If you are using a Report Footer, then ....
On the Report properties Format tab, set the
Page Footer property to
Not with Rpt Ftr

If you are not using a Report Footer, add a control to the Page Footer
to calculate pages, i.e. = [Pages] (or you may already have one
similar to = "Page" & [Page] & " of " & [Pages]). It does not need to
be Visible.

Then code the Page Footer Format event:
Cancel = Me.[Page] = [Pages]

 

[Guest]

Terrific! Thanks!

I have a report that I want to control the page footer such that it is NEVER
printed on the last page of the report. If the report is only one page long
(the last page is also the first page) the page footer won't be printed.

Suggestions?

Thanks.

If you are using a Report Footer, then ....
On the Report properties Format tab, set the
Page Footer property to
Not with Rpt Ftr

If you are not using a Report Footer, add a control to the Page Footer
to calculate pages, i.e. = [Pages] (or you may already have one
similar to = "Page" & [Page] & " of " & [Pages]). It does not need to
be Visible.

Then code the Page Footer Format event:
Cancel = Me.[Page] = [Pages]