If Statement Help Please

  • Thread starter Thread starter Dave
  • Start date Start date
D

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
 
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.
 
-----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
Click to expand...
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 ""
 
Back
Top