VB in Event Procedure for conditional page break

[Minimorgie]

Hi,

I'm producing a duplex report in Access 2003, on the reverse page are diary comments which sometimes go over one page, this throws what should be the front page onto the back page. The diary comments are inserted via a sub-report. In the main report I'm trying to create a conditional page break using VB. I've inserted the page break and called it CondPgBreak and in the page header section have set the following so that a break does not always happen :

Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer)
Me![CondPgBreak].Visible = False
End Sub

In the footer I want to set a page throw wherever the page number is not odd, what should I put in the following where I have inserted the ???? :

Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
If (Me.Page ????????) Then
Me![CondPgBreak].Visible = True
End If
End Sub

OR am I going about this in totally the wrong way?

Any help would be much appreciated.

 

[JerryKlmns]

You 'll probably get better answers in forum703