Problem checking for Null Value of a Textbox.

[SIGMA248]

HI,



I am having trouble testing for the Null Value of a Textbox. In the following code when each one of the Textbox's is Null I want to do the Then code.

If Form_Contacts.Call_Listing_Subform.Form![txtFUDate].Value = Null And Form_Contacts.Call_Listing_Subform.Form![txtSubject].Value = Null And Form_Contacts.Call_Listing_Subform.Form![txtFinalised].Value = Null Then

Code goes here.

End If

When I break the code, when the Textbox's Value = Null the Then Code is not executed. What am I doing wrong?

Thanks,

Dean.

[pbaldy]

Nothing is ever = to Null. You can use the IsNull() function to test, or this tests for both Null and a zero length string:

If Len(Whatever & vbNullString) = 0 Then

replacing Whatever with the appropriate form reference, variable, etc.

[Rawb]

If Len(Whatever & vbNullString) = 0 Then

Not that I'm stalking you or anything. . .

But this.

Is.

AWESOME!

[pbaldy]

LOL! Wish I could take credit, but I got it from somebody else.

Stalkers should be warned that my wife carries pepper spray and isn't afraid to use it.