Vis. Basic Code Needed

[niall]

I have never programmed in VB before and need a few lines for a macro in an access db.

I am inserting OLE's (word documents) into a report. However there is not enough room because of my page header. So I need a program that will take out my page header where there is an OLE (or every other page).

Thank you in advance.

Niall

 

[pdx_man]

Rename the Page Header to something else like ... MyNextPage
Then try:

Private Sub Report_Page()

    If Me.Page Mod 2 = 0 Then
        Me.MyNextPage.Visible = False
    Else
        Me.MyNextPage.Visible = True
    End If

End Sub