- A ListBox Object a control on a form that allows you to select a value from a list rather than typing it into a text box. A list box serves a similar function to a combo box, but it does not use a drop-down feature. ListBox Objects are helpful when you want to view some or all your options continuously. Like a combo box, a list box can display one or more related columns at a time.
- The values displayed in a list box depends on the record source. When creating a ListBox Control, you can select from an existing table or insert new values. If you select from an existing table, the columns and records are restricted to the data in that table. If you insert new values, you have more freedom to choose the contents of the list box without affecting other objects. Values selected from a new list are not saved to an underlying table.
- The MultiSelect property allows you to select more than one value in a list box on a form. To maintain data integrity, each field needs to associate with a single value, but Access does some behind-the-scenes work to make multiple selections possible. The database saves the two or more values in separate records in the background and then recombines them whenever you access the record. Multiple selections streamline certain processes where more than one option is required.
- A form's Property Sheet provides access to a ListBox Control's properties and settings. Right-click the form's title in the Navigation Pane, select "Design View" and click the "Property Sheet" button on the Ribbon at the top of the page. Activate or deactivate the MultiSelect property by clicking the "Other" tab of the Property Sheet. Locate and edit the Record Source by selecting the "All" tab and clicking the drop-down box or the "..." button.
ListBox Object
Record Source
MultiSelect Options
Property Sheet
SHARE