Combobox question

C

Clay Forbes

Ok, i have tried a couple different things but i can not figure out
how to make it so when user clicks cmd button it checks to see if
combo3 is empty.
 
J

John Spencer (MVP)

Wrong Group, but assuming that the button and the combo are on the same form you
can check the combobox value

If Len(Me.Combo3 & vbNullstring) = 0 Then
'NEVER MIND
Else
'Execute the existing code

End if
 
C

Clay Forbes

Its not. Does it need to be? if so can you give me the name of a group
that i should post it to?
 
C

Clay Forbes

what does the expression Len mean?

John Spencer (MVP) said:
Wrong Group, but assuming that the button and the combo are on the same form you
can check the combobox value

If Len(Me.Combo3 & vbNullstring) = 0 Then
'NEVER MIND
Else
'Execute the existing code

End if
Click to expand...
 
J

John Spencer (MVP)

It is a function that returns the LENgth of a string.

So if your combo is null or contains a string the is zero-characters long, the
function will return zero. Adding a zero-length string (vbNullString) to a null
gives you a zero-length string and add a zero-length string to a zero-length
string also gives you a zero-length string.
 
Top