No Header on Page One Please

[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

 

[Rick Brandt]

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?

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".

 

[Robin Chapple]

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".

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?

 

[Rick Brandt]

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.

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.

 

[Robin Chapple]

Thanks very much. I did not understand properly.

It works just as you predicted.

Cheers,

Robin Chapple