Check combobox is not blank

C

chrisjames25

Registered User.

Local time

Today, 03:50

Joined

Dec 1, 2014

Messages

404

• Mar 30, 2018

• #1

Hi

I currently use the following code to check if a textbox is blank when i click an enter command button:

Code:

    If Nz(Me.Txt_NewTier1, "") = "" Or Len(Trim(Me.Txt_NewTier1) & vbNullString) = 0 Then

     ' Enter message here
        Exit Sub
else
    End If

My question is is this the right way to test whether a combobox also isn't blank and has a valid entry.

 

Ranman256

Well-known member

Local time

Yesterday, 22:50

Joined

Apr 9, 2015

Messages

4,354

• Mar 30, 2018

• #2

Combos are usually null,

If IsNull(cboBox) then

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Today, 10:50

Joined

May 7, 2009

Messages

20,334

• Mar 30, 2018

• #3

Check its listidex, if -1 then the combo is blank or not in list

If Me.combo.listindex> -1 then
' value is valid

 

C

chrisjames25

Registered User.

Local time

Today, 03:50

Joined

Dec 1, 2014

Messages

404

• Mar 30, 2018

• #4

Brilliant, thanks for both suggestions.