title | keywords | f1_keywords | ms.service | ms.assetid | ms.date | ms.localizationpriority | |
---|---|---|---|---|---|---|---|
List Box Control |
vbaac10.chm5186557 |
|
access |
279e2f07-9f6d-df03-812c-d232cdeb6fd7 |
06/08/2017 |
medium |
Applies to: Access 2013 | Access 2016
The list box control displays a list of values or alternatives. In many cases, it's quicker and easier to select a value from a list than to remember a value to type. A list of choices also helps ensure that the value that's entered in a field is correct.
The list in a list box consists of rows of data. Rows can have one or more columns, which can appear with or without headings.
If a multiple-column list box is bound, Microsoft Access stores the values from one of the columns.
Use an unbound list box to store a value that you can use with another control. For example, you could use an unbound list box to limit the values in another list box or in a custom dialog box. You could also use an unbound list box to find a record based on the value you select in the list box.
If you don't have room on your form to display a list box, or if you want to be able to type new values as well as select values from a list, use a combo box instead of a list box.
- Access for developers forum
- Access help on support.office.com
- Access help on answers.microsoft.com
- Search for specific Access error codes on Bing
- Access forums on UtterAccess
- Access wiki on UtterAccess
- Access developer and VBA programming help center (FMS)
- Access posts on StackOverflow
[!includeSupport and feedback]