Access VBA

This category holds articles regarding Access VBA, but also general things I come accross Access and its usage in companies.

In case you need the selected list item from a listbox, which only allows single selection the selected list item can be returned using the below source code.

Source Code

1
Me.listBox.column(0)

Where listBox is the name of the control element / the listbox as you defined it.

Me refers to a form a listbox is placed in.

The column index within a listbox is zero based.

Subcategories