Page header not on first page? 1

[BillyL]

Is there a way to not have the page header text appear on the first page of a report but to appear on all other pages?

 

[scking]

Yes and I'll just give you the concept. I'm not sure of the exact syntax but I believe it probably involves the visible property.

In the OnFormat event write this type of code.

If Me.Page < 2 Then
Me.PageHdr.Visible = False
Else
Me.PageHdr.Visible = True
End If

Steve King Professional growth follows a healthy professional curiosity

 

[BillyL]

I tried your code and I got an Invalid Qualifier error message.

It idendified the &quot;Me.PageHeader.Visible=False&quot; text as the problem (it actually highlighted the PageHeader text only). I also attempted to write the code in the On Page property of the report but the same error message occurred.

Any ideas?

 

[PaulF]

Use the Report Header and not the Page Header

PaulF

 

[BillyL]

I tried the the code in the ONFormat event in the Report Header and got the same error message. PaulF, did it work for you whe you tried it?

 

[PaulF]

Sorry I misread the question. If you want the page header info to appear only on the first page, use the Report Header, but since you want the page header info to appear on all pages &quot;except&quot; the first one, use this:
(I named my Page Header PgHdr, change the code to match the name of your Page Header, just don't use PageHeader)

Private Sub PgHdr_Format(Cancel As Integer, FormatCount As Integer)
If Me.Page = 1 Then
Me.PgHdr.Visible = False
Else
Me.PgHdr.Visible = True
End If

End Sub

PaulF