How to determine if any row is selected in a listbox

ms-access listbox vba ms-access-2003
got2nosth picture got2nosth · Jan 10, 2014 · Viewed 32.6k times · Source

I have a list box in my Access form. I need to know if any of the rows in this list box has been selected by the user. Is there any simple Access property or method exists for this purpose? I do not want to loop through the listbox to check if any row's selected property is true, because I am only interested to know if a selection action is done.

Answer

HansUp picture HansUp · Jan 10, 2014

A list box has the ItemsSelected property which returns a read-only reference to the hidden ItemsSelected collection. And you can ask for the Count property of that collection ...

MsgBox Me.YourListBoxName.ItemsSelected.Count & " items selected"

Related questions

removing multiple selected items in a listbox - code only recognising first selection

I have two listboxes and am trying to add items from List 1 to List 2, and then be able to remove multiple items from List 2 at once. Note that List 1 stays stagnant (this is how it is supposed to be). I …

Read More
Is there a way to right-align a numeric column in a ListBox

We have a standard Access listbox with multiple columns. Is there a way to have integer or currency columns right aligned?

Read More
How to populate a ListBox with a ADODB.Recordset (Error 91) To Do Autocompletion in Access

I work on an Access DB and I have to use a Datasource connection to a SQL Server. To do that I use the ADODB object with : -ADODB.Connection -ADODB.Recordset Code Up-to-date, following an observation of Ian Kenney Dim …

Read More