If Statement (1 Viewer)

[DebbieV]

I am trying to create a If statement that will dim out a text box. I typed the following code
If [Date_Returned]> 5/31/2002 then
txtMaryland20.Enabled = False
End If
I complied this and no errors pop up. When I entered data in with a returned date greater than 5/31/02 nothing different happens. It will not dim the Maryland20 text box.
I also had put in Dim ctl As Control
and Dim txtMaryland 20.
Not sure why this is not working, Please help

 

[Jerry Stoner]

Where did you put the code?

 

[Rich]

If [Date_Returned]> #05/31/2002# then
Me.txtMaryland20.Enabled = False
End If

 

[Jerry Stoner]

Duh! Thanks again Rich

 

[DebbieV]

Thank you Rich, its works great.