Problem with date code

[sandylt]

I am using the following code to make the duedate field on my report invisible if it is greater than firstofmonth field. Can someone tell me what I am doing wrong?

Private Sub Report_Open(Cancel As Integer)
If Me.[FirstOfMonth] >= "Date()" Then
Me.[DueDate].Visible = True
Else
Me.[DueDate].Visible = False
End If
End Sub

 

[KenHigg]

Private Sub Report_Open(Cancel As Integer)
If Me.[FirstOfMonth] >= Date() Then
Me.[DueDate].Visible = True
Else
Me.[DueDate].Visible = False
End If
End Sub


???
ken

 

[greaseman]

Hope this helps

Try putting your code onto the on page event:

Private Sub Report_Page()
If Me.FromDate >= "Date()" Then
Me.FromDate.Visible = True
Else
Me.FromDate.Visible = False
End If
End Sub

I just tried it on one of my reports and I got no errors.