Others

How to Sort an Access Combo Box by Its Second Column

Guest Writer Oct 10, 2026 869 views

Question details

The user needs to sort dropdown options in a Microsoft Access combo box by the visible text field (second column) rather than the hidden numeric ID (first column).

How to Sort an Access Combo Box by Its Second Column

Product: Microsoft Access
Device & OS: not provided
Scenario: Designing or modifying an Access form where a combo box fetches a numeric ID and a text description, but the dropdown list is currently organized by the ID.
Observed behavior: The combo box sorts items numerically by the stored ID field, causing the visible alphabetical descriptions to appear out of order for the end user.

Before you start

Ensure your form is closed or in Design View, and take note of the exact table or query names providing data to your combo box.

Solution 1Recommended

Modify the Combo Box RowSource SQL

Directly edit the SQL statement in the combo box properties to enforce an alphabetical sort on the description column.

By default, Access sorts data by the first column (usually the Primary Key ID). By adding an ORDER BY clause to the RowSource SQL, you can force the dropdown to sort by the readable text column instead.

Open Form in Design View

Right-click your form in the Navigation Pane and select 'Design View'.

Access the Property Sheet

Click on the target combo box to select it. Press F4 to open the Property Sheet on the right side of your screen.

Locate Row Source

Navigate to the 'Data' tab within the Property Sheet and find the 'Row Source' property field.

Update the SQL Statement

Append an ORDER BY clause to the existing SQL string. For example, change it to: SELECT ID, Description FROM TableName ORDER BY Description;

Verify Changes: Switch the form back to Form View and click the combo box dropdown to ensure the text descriptions are now sorted alphabetically.

Solution 2

Sort Using the Query Builder

Use the visual Query Builder interface to apply an ascending sort if you prefer not to write SQL code manually.

Free Microsoft Office alternative

Manage Data Easily with WPS Spreadsheet

While Microsoft Access requires complex SQL for simple tasks like sorting dropdowns, WPS Spreadsheet offers an intuitive, lightweight alternative for data management. It is highly compatible with Microsoft Excel formats, offering powerful data validation and sorting tools completely free of charge.

1. Select the Cell: Open WPS Spreadsheet and click the cell where you want to insert a sorted dropdown list.
2. Insert Data Validation: Navigate to the 'Data' tab on the ribbon and click on 'Validation'.
3. Configure the Dropdown: In the dialog box, set 'Allow' to 'List', select your alphabetically sorted data range, and click 'OK'.

Seamlessly compatible with Microsoft Excel (.xlsx, .xls) and CSV file formats.Create and sort dropdown lists instantly without writing any code.Lightweight, fast-loading application with a familiar tabbed interface.Completely free core features for seamless data entry and management.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my combo box display the ID number instead of the text description?

This occurs because the combo box is bound to the ID column and the column widths are not set correctly. To fix this, go to the 'Format' tab in the Property Sheet and set 'Column Widths' to '0cm;3cm' (or similar). This hides the first column (ID) and displays the second column (text).

Can I sort the combo box items by multiple columns?

Yes. You can sort by multiple fields by adding them to your ORDER BY clause in the RowSource. For example: SELECT ID, Category, Description FROM TableName ORDER BY Category, Description;

Will sorting the combo box also sort the main form's records?

No. Sorting the combo box's Row Source only affects the dropdown list items. To sort the actual records displayed on the form, you must apply the ORDER BY clause to the form's Record Source property instead.

Office Quick Solutions