No Value selected check on ListBox

[questionit]

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

[MikeTheBike]

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

[questionit]

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

[FishVal]

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

[missinglinq]

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

Public Sub cmd_btn_Click()
  If IsNull(ComboBox0.Value)  Then 
   '  Do something
  End If
End Sub

Linq ;0)>

[MikeTheBike]

I thought it would be possible to do like that.

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

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

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

If Combo0.ListIndex = -1 Then
    MsgBox "No Selection"
Else
    MsgBox "Item " & Combo0.ListIndex & " Selected"
End If

Should do it?

ListIndex is Zero based.

MTB

[questionit]

Yes that works MTB

Thanks

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

If Combo0.ListIndex = -1 Then
    MsgBox "No Selection"
Else
    MsgBox "Item " & Combo0.ListIndex & " Selected"
End If

Should do it?

ListIndex is Zero based.

MTB