checking if combobox any item choose

[Marco]

Hello.

How can I check if a combobox has any option choosed.

What I'm looking for iis something like:

if combo1.text = "" then
msgbox "Error"
end if


How can I do this?


Thanks,
Marco

 

[Dirk Goldgar]

Hello.

How can I check if a combobox has any option choosed.

What I'm looking for iis something like:

if combo1.text = "" then
msgbox "Error"
end if


How can I do this?


Thanks,
Marco

Generally, if no item in the combo box is chosen, the control's value will
be Null, You can't check whether the control = Null, because Null isn't
"equal" to anything, so you have to use the IsNull function:

If IsNull(Me!Combo) Then
MsgBox "Error"
End If

 

[Marco]

THANKS MAN.

Cheers,
Marco

Generally, if no item in the combo box is chosen, the control's value will
be Null, You can't check whether the control = Null, because Null isn't
"equal" to anything, so you have to use the IsNull function:

If IsNull(Me!Combo) Then
MsgBox "Error"
End If


--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)