Page Headers

[niall]

Hello everyone

I am inserting OLE objects into my report. Can I have a different page header where there is an OLE? Or can I have different page headers for odd and even pages?

Thanking you in advance
Niall

 

[Stuart Heath]

Page Header

In the on format event of your page header include code based on the fields you want to change your header on.

eg.

Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer)
If Me.Page / 2 = Int(Me.Page / 2) Then
Me!Label1.Caption = "Even"
Else
Me!Label1.Caption = "Odd"
End If
End Sub

Will change the contents of you label based on page count.

You can use the same principle on your ole control.