Office Settings & Configuration

How to Show Multiple Fields in an Access Combo Box When Closed

Aamir Naveed Akram Oct 8, 2026 869 views

Question details

The user needs a Microsoft Access combo box to display data from multiple fields even after the dropdown list is closed.

How to Display Multiple Fields in an Access Combo Box When Closed

Product: Microsoft Access
Device & OS: not provided
Scenario: Configuring the display format of a combo box so it shows comprehensive information instead of just a single bound field or ID.
Observed behavior: The combo box displays multiple columns while the dropdown list is open, but immediately reverts to showing only the first visible column when the list is closed.

Before you start

Before modifying your form controls, ensure your combo box's Row Source query includes all the fields you intend to display, and make a quick backup of your database layout.

Solution 1Recommended

Concatenate Fields and Adjust Column Widths

Combine multiple fields into one column in the query, and hide the primary key column by setting its width to zero.

By default, an Access combo box only displays the first column with a width greater than zero when closed. To show data from multiple columns, you must concatenate the desired fields in the Row Source query and adjust the column widths to hide the key field.

Open Row Source Query

Open your form in Design View, select the combo box, open the Property Sheet (F4), navigate to the Data tab, and click the ellipsis (...) next to the Row Source property.

Create a Concatenated Field

In the query builder, create a new combined field by typing an expression like: DisplayName: [FirstName] & " " & [LastName].

Set Column Count

Save and close the query. In the Property Sheet, go to the Format tab and ensure the Column Count property is updated to include your new concatenated field.

Adjust Column Widths

In the Format tab, set the Column Widths property to hide the key column and show the display column (for example, type 0cm; 5cm or 0"; 2").

Verify Bound Column

Return to the Data tab and verify that the Bound Column property is set to your hidden primary key (usually column 1) so data saves correctly.

Concatenate Fields and Adjust Column Widths

Prevent Related Record Errors: If selecting a value causes an error stating the related record must exist, confirm that your Bound Column corresponds to the correct numeric ID field, not the concatenated text field.

Solution 2

Recreate the Combo Box Using the Wizard

If you experience persistent data binding errors after modifying columns, using the Control Wizard can automatically configure the correct widths and bound columns.

Free Microsoft Office alternative

Enhance Your Productivity with WPS Office

While Microsoft Access manages your complex databases, WPS Office provides a free, lightweight, and comprehensive suite for all your daily document, spreadsheet, and presentation needs. Experience seamless compatibility with Microsoft formats without the heavy subscription costs.

1. Visit the official website: Navigate to the official WPS Office website to find the latest free version.
2. Download the installer: Click on the free download button tailored for your specific operating system (Windows, Mac, or Linux).
3. Install and launch: Run the setup file and follow the on-screen instructions to start using your new office suite.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Free, lightweight design that installs quickly and runs smoothly on older devices.Familiar user interface requiring zero learning curve for Microsoft Office users.Built-in PDF toolkit to edit, merge, and convert documents effortlessly.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my combo box only display the ID number instead of the name?

This happens when the first visible column in your combo box is the ID field. To fix this, change the Column Widths property in the Format tab to set the ID field's width to zero (e.g., 0"; 1"), which hides the ID and forces the name column to display.

Can a closed Access combo box show two separate columns side by side?

No, a closed combo box in Microsoft Access can only display the first column that has a width greater than zero. To show data from multiple columns when closed, you must concatenate the fields into a single column using an expression in the Row Source query.

How do I fix the 'related record is required' error after changing my combo box display?

This error generally occurs if the Bound Column property is incorrectly set to the concatenated text field instead of the foreign key field. Check the Data tab of the Property Sheet and ensure the Bound Column is set to the index of your hidden primary key (usually 1).

Office App Problems