No Header on Page One Please

  • Thread starter Thread starter Robin Chapple
  • Start date Start date
R

Robin Chapple

I have a report where I have a report header with 16pt text.

I need a page header with the same text but smaller. I have made this
but I do not need it on page one.

I have added a control in the page footer named "PageNo" with control
source set to =[Page].

In the format event of the page header, I have put this code:

Cancel = (Me!PageNo = 1)

copied from help that I had years ago and which worked.

This time the error message says the ACCESS can't find the macro.

What have I done wrong?

Thanks,

Robin Chapple
 
Robin Chapple said:
I have a report where I have a report header with 16pt text.

I need a page header with the same text but smaller. I have made this
but I do not need it on page one.

I have added a control in the page footer named "PageNo" with control
source set to =[Page].

In the format event of the page header, I have put this code:

Cancel = (Me!PageNo = 1)

copied from help that I had years ago and which worked.

This time the error message says the ACCESS can't find the macro.

What have I done wrong?
Click to expand...

You're working harder than you need to. The report has a property called
PageHeader and one of the possible values is "Not with Rpt Hdr".
 
I didn't know that but I DO need the Report Header but I DO NOT need a
page header on page one.

I know it is possible but I cannot find the working example.

You're working harder than you need to. The report has a property called
PageHeader and one of the possible values is "Not with Rpt Hdr".
Click to expand...
Robin Chapple said:
I have a report where I have a report header with 16pt text.

I need a page header with the same text but smaller. I have made this
but I do not need it on page one.

I have added a control in the page footer named "PageNo" with control
source set to =[Page].

In the format event of the page header, I have put this code:

Cancel = (Me!PageNo = 1)

copied from help that I had years ago and which worked.

This time the error message says the ACCESS can't find the macro.

What have I done wrong?
Click to expand...
Click to expand...
 
Robin Chapple said:
I didn't know that but I DO need the Report Header but I DO NOT need a
page header on page one.

I know it is possible but I cannot find the working example.
Click to expand...

That is exactly what that setting I gave you does. It tells Access "I don't
want to see the PageHeader on the same page where there is a ReportHeader".
Therefore it is suppressed on the first page of the report.
 
Thanks very much. I did not understand properly.

It works just as you predicted.

Cheers,

Robin Chapple
 
Back
Top