Combo Box Control.
You can use the AutoExpand property to specify whether Microsoft Access automatically fills the text box portion of a combo box with a value that matches the characters as you type in the combo box. This lets you quickly enter an existing value in a combo box without displaying the list box portion of the combo box.
The AutoExpand property has the following settings.
| Setting | Description | Visual Basic |
| Yes | (Default) Microsoft Access fills in the combo box from the list with the first value matching the first character that you type. As you type additional characters, Microsoft Access changes the value displayed to match all the characters typed. | True (-1) |
| No | You must select a value from the list or type the entire value. | False (0) |
You can set the AutoExpand property using the combo box’s property sheet, a macro, or Visual Basic.
When you enter characters in the text box portion of a combo box, Microsoft Access searches the values in the list to find those that match the characters you have typed. If the AutoExpand property is set to Yes, Microsoft Access automatically displays the first underlying value that matches the characters entered so far.