Toggling Off the Page Header on First Page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'd like to toggle the page header off on the first page of my report using
the Visible property of the section in the Print event procedure. Looking
through the VBA functions, I didn't find one that returns the page number.
Is there a function or system variable that can give me this value?

Thanks for all thoughtful responses.

Sprinks
 
I'd like to toggle the page header off on the first page of my report using
the Visible property of the section in the Print event procedure. Looking
through the VBA functions, I didn't find one that returns the page number.
Is there a function or system variable that can give me this value?

Thanks for all thoughtful responses.

Sprinks
Click to expand...

1) A report's page number is Page.
Page is not a function it is a report property.

2) Reports have a PageHeader property. If you are showing a Report
Header along with a page header, you can set the PageHeader property
to
Not with Rpt Hdr.
It's on the Report's Property sheet's Format tab.

3) If you are not displaying a report header, then you can code the
Page Header FORMAT event:
Cancel = Me.[Page] = 1
 
Thanks, Fred. Exactly what I needed. And NO code to develop, support, etc.!

Best regards.
Sprinks

fredg said:
I'd like to toggle the page header off on the first page of my report using
the Visible property of the section in the Print event procedure. Looking
through the VBA functions, I didn't find one that returns the page number.
Is there a function or system variable that can give me this value?

Thanks for all thoughtful responses.

Sprinks
Click to expand...

1) A report's page number is Page.
Page is not a function it is a report property.

2) Reports have a PageHeader property. If you are showing a Report
Header along with a page header, you can set the PageHeader property
to
Not with Rpt Hdr.
It's on the Report's Property sheet's Format tab.

3) If you are not displaying a report header, then you can code the
Page Header FORMAT event:
Cancel = Me.[Page] = 1
Click to expand...
 
Back
Top