list box item selected?

  • Thread starter Thread starter Fredrated
  • Start date Start date
F

Fredrated

Is there an easy way to tell if a list box has had an item selected?

Or is the only way to grab the selected items, then see if you got anything?

Thanks in advance for any help.

Fred
 
In the VBA module associated with the form, you can check
Me![NameOfListbox].ItemsSelected.Count It'll be 0 if nothing's selected.

From elsewhere, use Forms![NameofForm]![NameOfListbox].ItemsSelected.Count
 
Thanks, this is a big help!

Fred

Douglas J. Steele said:
In the VBA module associated with the form, you can check
Me![NameOfListbox].ItemsSelected.Count It'll be 0 if nothing's selected.

From elsewhere, use Forms![NameofForm]![NameOfListbox].ItemsSelected.Count

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Fredrated said:
Is there an easy way to tell if a list box has had an item selected?

Or is the only way to grab the selected items, then see if you got
anything?

Thanks in advance for any help.

Fred
Click to expand...
Click to expand...
 
Back
Top