Blank Field Issue 2

[netrusher]

I feel like I should know the answer to my problem but it is not working. Please see code below. What I am
wanting to do is: When I click a yes/no checkbox on my form (ChangeStandardHours) and the (ProjectNbr)
text box is Blank, then I want the (Ctl1_8ton_pending_approval) CheckBox to be enabled. It starts off non
enabled. I can get this to work if the (ProjectNbr) CheckBox is not Blank but not when it is Blank it will not work.
Can someone point out what I am doing wrong and how to fix it?

If Me.ChangeStandardHours = True And Me.ProjectNbr = Blank Then
Me.Ctl1_8ton_pending_approval.Enabled = True
End If

 

[danvlas]

If Me.ChangeStandardHours = True And IsNull(Me.ProjectNbr) Then


or

If Me.ChangeStandardHours = True And Nz(Me.ProjectNbr,"") = "" Then

except for the case where you have some variable named Blank...

HTH




Daniel Vlas
Systems Consultant

 

[PHV]

Me!Ctl1_8ton_pending_approval.Enabled = (Me!ChangeStandardHours And (Trim(Me!ProjectNbr & "") = ""))

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886