View Full Version : Report Headers


alastair69
01-11-2006, 05:19 AM
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
:D

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

Hayley Baxter
01-11-2006, 05:36 AM
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
01-11-2006, 06:08 AM
Thank you very much did the job.

Alastair