If Statement Help Please

[Dave]

If Text362 has a value and Text400 does not, then Message Box,Code
below does not work.
Text362 is a Numeric field and Text400 is a Text Field.

If Not IsNull(Text362) And IsNull(Text400) Then
MsgBox "Choose How Invoice is to be Sent"

End If

 

[Brendan Reynolds]

Perhaps the text box may contain an empty string, which is visually
indistinguishable from a Null value. The following should work with either
Null or an empty string ...

Private Sub Command4_Click()

If Len(Me!Text0 & vbNullString) > 0 And Len(Me!Text2 & vbNullString) = 0
Then
MsgBox "Text0 is neither Null nor an empty string, text2 is either
Null or an empty string."
End If

End Sub

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[vmerchand]

-----Original Message-----
If Text362 has a value and Text400 does not, then Message Box,Code
below does not work.
Text362 is a Numeric field and Text400 is a Text Field.

If Not IsNull(Text362) And IsNull(Text400) Then
MsgBox "Choose How Invoice is to be Sent"

End If

I tested your code and is working, if text362 has 1 and
text400 has "" the msgbox appears and go to the next
record, maybe I did not understand you problem, or you
can try with an If statement to 0 and to ""