Code to determine if no entry in combobox

[projecttoday]

LenB(Nz(Me.Textbox, vbNullString))

This is 0 if there is nothing in the textbox. But it doesn't seem to work for a combobox. How can I test a combobox for no entry?

 

[Remou]

You could use IsNull

If IsNull(Me.cboCombo) Then

But you may find that:

If Trim(Me.SomeControl & "") = vbNullString Then

Suits most things.

http://lessthandot.com