By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,968 Members | 1,588 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,968 IT Pros & Developers. It's quick & easy.

Check for null entry in combo box

P: n/a
Jim
I am trying to use a combo box in order to write a query on the fly. I
want to check for a null entry so i can replace it with "Like *" or
similar.

If Combo0.Value = Null Then MsgBox ("null")

this however doesnt seem to work... even when there is no value set the
msgbox doesnt appears

any help much appreciated...
thanks

jim
Oct 22 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"Jim" <ji*@nospam.comschreef in bericht
news:12*************@corp.supernews.com...
>I am trying to use a combo box in order to write a query on the fly. I want
to check for a null entry so i can replace it with "Like *" or similar.

If Combo0.Value = Null Then MsgBox ("null")

this however doesnt seem to work... even when there is no value set the
msgbox doesnt appears

any help much appreciated...
Try:

If IsNull(Combo0) Then
MsgBox ("null")
End If

john
Oct 22 '06 #2

P: n/a
Jim
thanks, john, you are a scholar!

john wrote:
"Jim" <ji*@nospam.comschreef in bericht
news:12*************@corp.supernews.com...
>I am trying to use a combo box in order to write a query on the fly. I want
to check for a null entry so i can replace it with "Like *" or similar.

If Combo0.Value = Null Then MsgBox ("null")

this however doesnt seem to work... even when there is no value set the
msgbox doesnt appears

any help much appreciated...

Try:

If IsNull(Combo0) Then
MsgBox ("null")
End If

john

Oct 22 '06 #3

P: n/a
"Jim" <ji*@nospam.comschreef in bericht
news:12*************@corp.supernews.com...
thanks, john, you are a scholar!
Hm, not really, just happened to have asked the same question a few weeks
ago ;-)
john
Oct 22 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.