Suppress Header last page

[Guest]

Hello -

I want to suppress the header on the last page of a report. How do I do that?

Any help will be greatly appreciated!

 

[fredg]

Hello -

I want to suppress the header on the last page of a report. How do I do that?

Any help will be greatly appreciated!

If you are including a Report footer in the report, you can set the
Report's PageHeader property to "Not with RptFtr".
It's on the Report's property sheet Format tab.

Or...
You can add an unbound control to the report:
=[Pages]
if you don't already have one, and code the PageHeader Format event:
Cancel = Me.[Page] = Me.[Pages]

 

[Guest]

Thanks, Fred!
--
Sandy

Hello -

I want to suppress the header on the last page of a report. How do I do that?

Any help will be greatly appreciated!

If you are including a Report footer in the report, you can set the
Report's PageHeader property to "Not with RptFtr".
It's on the Report's property sheet Format tab.

Or...
You can add an unbound control to the report:
=[Pages]
if you don't already have one, and code the PageHeader Format event:
Cancel = Me.[Page] = Me.[Pages]