I have a combo box on a form which may sometimes have a null value in it. There is no way around that. It's complicated. Please just take my word for it.

Is there a way to test for a null value in it?

IsNull(me.ComboBox1.Value) isn't working. It's thowing an error, saying, "you entered an expression that has no value".

Thanks.

Aaron

Aaron,
do you have your combo box set to limit to list?

Kevin

dartcoach

Ok bud. Here you go:

If isnull(me.ComboBox1.Column(0))

The column function will examine each item in your combo list. It is zero relative, but don't let that scare you. All that means is that the first item in your list starts at 0 and the second one will be 1 and so on.

Also, you can use the column function to set values you have dim or other values in your form. Example:

Dim strItem1 as String

strItem1 = Me.ComboBox1.Coulmn(0)
if isnull(strItem1) then
.
.
.
.
endif

txtItem2 = Me.ComboBox1.Coulmn(1)
'Seeing that maybe txtItem2 is a test Box on your form.

I hope this helps out. Please let me know.

Ru1