Table of contents
Collapse the table of content
Expand the table of content

ComboBox.LimitToList Property (Access)

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

You can use the LimitToList property to limit a combo box's values to the listed items. Read/write Boolean.


expression. LimitToList

expression A variable that represents a ComboBox object.


The LimitToList property uses the following settings.

SettingVisual BasicDescription
YesTrueIf the user selects an item from the list in the combo box or enters text that matches a listed item, Microsoft Access accepts it. If the entered text doesn't match a listed item, the text isn't accepted and the user must then retype the entry, select a listed item, press ESC, or click Undo on the Edit menu.
NoFalse(Default) Microsoft Access accepts any text that conforms to the ValidationRule property.

For table fields , you can set this property on the Lookup tab of the Field Properties section of table Design view for fields with the DisplayControl property set to Combo Box.

Note Microsoft Access sets the LimitToList property automatically when you select Lookup Wizard as the data type for a field in table Design view.

When the LimitToList property of a bound combo box is set to No, you can enter a value in the combo box that isn't included in the list. Microsoft Access stores the new value in the form's underlying table or query (in the field specified in the combo box's ControlSource property), not the table or query set for the combo box by the RowSource property. To have newly entered values appear in the combo box, you must add the new value to the table or query set in the RowSource property by using a macro or Visual Basic event procedure that runs when the NotInList event occurs.

Setting both the LimitToList property and the AutoExpand property to Yes lets Microsoft Access find matching values from the list as the user enters characters in the text box portion of the combo box, and restricts the entries to only those values.

Note If you set the combo box's BoundColumn property to any column other than the first visible column (or if you set BoundColumn to 0), the LimitToList property is automatically set to Yes.

When the LimitToList property is set to Yes and the user clicks the arrow next to the combo box, Microsoft Access selects matching values in the list as the user enters characters in the text box portion of the combo box, even if the AutoExpand property is set to No. If the user presses ENTER or moves to another control or record, the selected value appears in the combo box.

Combo boxes accept null values when the LimitToList property is set to Yes or True, whether or not the list contains null values. If you want to prevent users from entering a null value in a combo box, set the Required property of the field in the table to which the combo box is bound to Yes.

Link provided by:Community Member Icon Luke Chung,FMS, Inc.


The following example limits a given combo box's values to its listed items.

Forms("Order Entry").Controls("States").LimitToList = True  

About the Contributors

Luke Chung is the founder and president of FMS, Inc., a leading provider of custom database solutions and developer tools.

See also


ComboBox Object

© 2018 Microsoft