Access VBA ListBox check if selected

How to check if No Value was selected from List-Box without using any built-in Events ?

Follow Post Reply

Hi

How to check if No Value was selected from List-Box without using any built-in Events ?

If you do not use an event, how does Access know you want to know if anything is selected ?

MTB

reply

I thought it would be possible to do like that.

for example, i click on a button and i write the following code :

[code]
Public Sub cmd_btn_Click()
If ComboBox0.Value = "" Then <-- this or anyother method doesn't work, why?
' Do something
End If

Hi

If you do not use an event, how does Access know you want to know if anything is selected ?

MTB

reply

How to check if No Value was selected from List-Box without using any built-in Events ?

Depends on MultiSelect property of ListBox.

For ListBox with MultiSelect set to None
ListBox.Value = Null
when nothing is selected

For ListBox with MultiSelect set to Simple/Extended
ListBox.ItemsSelected.Count = 0
when nothing is selected

reply

He says "listbox" in his title but from his code he's using a combobox. This should do it
Linq ;0)>

reply

I thought it would be possible to do like that.

for example, i click on a button and i write the following code :

Expand|Select|Wrap|Line Numbers

1. PublicSubcmd_btn_Click()
2. IfComboBox0.Value=""Then<--thisoranyothermethoddoesn'twork,why?
3. 'Dosomething
4. EndIf

The last time I look a button click was classed as an event !

Should do it?

ListIndex is Zero based.

MTB

reply

Yes that works MTB

Thanks

The last time I look a button click was classed as an event !

Expand|Select|Wrap|Line Numbers

1. IfCombo0.ListIndex=-1Then
2. MsgBox"NoSelection"
3. Else
4. MsgBox"Item"&Combo0.ListIndex&"Selected"
5. EndIf

Should do it?

ListIndex is Zero based.

MTB

reply