Suppress Header last page

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sandy - 23 Dec 2005 18:44 GMT

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!

Signature

Sandy

Reply to this Message

fredg - 23 Dec 2005 20:10 GMT

> 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]

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

Sandy - 26 Dec 2005 17:04 GMT

Thanks, Fred!

Signature

Sandy

> > Hello -
> >
[quoted text clipped - 10 lines]
> if you don't already have one, and code the PageHeader Format event:
> Cancel = Me.[Page] = Me.[Pages]

Reply to this Message