Others

How to Highlight the First Remaining Item in an Access Combo Box

Amos Gikunda Oct 1, 2026 868 views

Question details

The user wants to visually highlight the first remaining item in an Access combo box after filtering by typing, allowing them to press Enter to select it manually without having the value assigned automatically.

How to Highlight the First Remaining Item in an Access Combo Box

Product: Microsoft Access
Device & OS: not provided
Scenario: Filtering a combo box dynamically as the user types and attempting to highlight the remaining item for keyboard selection.
Observed behavior: Access natively assigns the item as the value of the control when using ItemData in VBA, rather than simply highlighting the row.

Before you start

Ensure your Access database is backed up and that you have basic familiarity with Visual Basic for Applications (VBA) and Access Form design.

Solution 1Recommended

Workaround: Programmatically Set Focus and Open Dropdown

Since Microsoft Access does not support a distinct 'highlighted but not selected' state, you can use VBA to set focus and open the dropdown list to prompt manual selection.

In Microsoft Access, once an item is programmatically selected in a combo box list, it immediately becomes the value of the control. To avoid automatically assigning the value while still guiding the user, the best approach is to ensure the dropdown remains open and focused.

Open Form in Design View

Right-click your form in the Access navigation pane and select 'Design View'.

Access the On Change Event

Click on your combo box. Open the Property Sheet (press F4), navigate to the 'Event' tab, and click the ellipsis (...) next to the 'On Change' property to open the VBA editor.

Insert Dropdown Code

Inside the event procedure, insert code to keep the dropdown open as the user types. Use 'Me.YourComboBoxName.SetFocus' followed by 'Me.YourComboBoxName.Dropdown'.

Workaround: Programmatically Set Focus and Open Dropdown

Limitation Note: This method does not explicitly highlight the first item, but it keeps the filtered list visible so the user can easily press the down arrow and Enter to select the remaining item.

Solution 2

Alternative: Auto-Assign Value Using ItemData

If you are willing to automatically assign the value when the list is filtered down to a single item, use the ItemData property in VBA.

Free Microsoft Office alternative

Try WPS Office for your Document and Spreadsheet Needs

While WPS Office does not include a database management tool like Microsoft Access to fix combo box properties directly, it provides an exceptional, free alternative for your Word, Excel, and PowerPoint tasks. Enjoy a lightweight suite to manage your exported database reports.

1. Download the Installer: Visit the official WPS website and download the free installer for your operating system.
2. Install the Software: Run the setup file and follow the simple on-screen instructions to complete the installation.
3. Open WPS Spreadsheets: Launch WPS Spreadsheets to easily format, analyze, and print the data you export from your Access databases.

Seamlessly handle exported Access data with robust Microsoft Excel format compatibility.Free, lightweight, and fast to install on multiple operating systems.Familiar tabbed user interface for an incredibly easy transition.Built-in PDF editing and conversion tools.

microsoft office alternative - wps office

Frequently Asked Questions

Can I highlight an item in an Access combo box without changing its value?

Natively, Access assigns the value to the control once an item is selected or assigned via VBA. True 'highlight-only' states are not supported out-of-the-box, so developers usually rely on keeping the dropdown open as a workaround.

What does Me.ComboBox.ItemData(0) do in VBA?

It retrieves the value of the bound column for the very first item (index 0) currently available in the combo box list. If the list is filtered, it grabs the first remaining item.

How do I trigger VBA code exactly when filtering a combo box?

Use the 'On Change' event of the combo box. This event fires every time the user types or deletes a character, allowing you to dynamically evaluate the ListCount and apply custom logic.

Office Quick Solutions