Report Headers

[alastair69]

Hello All,

Is there a way of getting a report to show the headers only after the first page and how would i go about this!

Alastair


**************************** RESOLVED THANKS TO HAYLEY BAXTER **********************************

 

[Hayley Baxter]

Hi Alastair

You can achieve this by puting the following code in the Page Header Section Format event

Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As
Integer)
If (Me.page = 1) Then
' Save the page header section height
ht = Me.PageHeaderSection.Height
Me.PageHeaderSection.Height = 0
Cancel = True
Else
Me.PageHeaderSection.Height = ht
End If
End Sub

Hay

 

[alastair69]

Thank you very much did the job.

Alastair