Identifying a null value in a combo box

[S2000magician]

I have a combo box whose dropdown menu contains dates.

I discovered that if the user doesn't select a date from the dropdown menu (e.g., clicks on the dropdown menu, then clicks somewhere else), then the combo box value is Null.

When I try to test for a null value (i.e., If combo_box_1.Value = Null Then . . . .), it never recognizes the null value; it doesn't execute the "Then . . . ." code.

So . . . how can I identify a null value in a combo box?

Thanks, guys! This one's vexing me.

[June7]

Cannot compare anything to null, will always return Null, not True or False, even Null = Null.

Review http://allenbrowne.com/casu-12.html

[pbaldy]

If you think of Null as "unknown", you'll realize that nothing can ever be "equal to" it. Try

If IsNull(combo_box_1.Value) Then

or this which tests for both Null and a zero length string:

If Len(combo_box_1.Value & vbNullString) = 0 Then

[S2000magician]

If you think of Null as "unknown", you'll realize that nothing can ever be "equal to" it. Try

If IsNull(combo_box_1.Value) Then

or this which tests for both Null and a zero length string:

If Len(combo_box_1.Value & vbNullString) = 0 Then

Awesome, Paul!

(Thanks, too, to June7.)

That did the trick!

[pbaldy]

Happy to help!