Others

Fix an Access Combo Box Saving the Wrong Column

Steven ParkerSteven Parker Nov 14, 2026 868 views

Question details

The user needs an Access combo box to save the customer name while displaying the state, customer name, and city.

Fix an Access Combo Box Saving the Wrong Column
Product
Microsoft Access
Device & OS
not provided
Scenario
A form uses a combo box with a three-column row source to select a customer.
Observed behavior
The combo box saves the state instead of the customer name because its Bound Column is set incorrectly.
Before you start

Open the form in Design View and select the combo box. On the Property Sheet, check its Row Source, Control Source, and current column order; confirm that the destination field can store a customer name.

Solution 1Recommended

Bind the customer name and display a combined customer label

Use this approach to save the customer name while showing the state, name, and city together in the combo box.

Access Bound Column values start at 1. By contrast, the combo box Column property used in code is zero-based: Column(0) refers to the first column.

The example uses Customers, CustomerName, State, and City as placeholder table and field names. Replace them with the names in your database.

1
Open the combo box properties

Open the form in Design View, select the combo box, and open the Property Sheet. On the Data tab, check that Control Source points to the field where the customer name should be saved.

2
Set the row source

On the Data tab, set Row Source Type to Table/Query. In Row Source, enter a query such as SELECT [CustomerName], [State] & ', ' & [CustomerName] & ', ' & [City] AS DisplayText FROM [Customers];, using your actual table and field names.

3
Bind the first column

On the Data tab, set Bound Column to 1 so the combo box stores CustomerName, the first column in the query.

4
Show the combined label

On the Format tab, set Column Count to 2 and Column Widths to 0;3 inches, or equivalent widths in your units. This hides the customer-name column and displays the combined label.

5
Test the selection

Switch to Form View, select a customer from the combo box, and save the record. Check the destination field to confirm that it contains the customer name.

Bind the customer name and display a combined customer label
Check for duplicate names: If customer names are not unique, storing a customer ID instead is generally safer for identifying records. The destination field and Bound Column must then be configured for that ID.
Free Microsoft Office alternative

Work with customer lists in WPS Office

WPS Office is a free, lightweight alternative for working with documents and spreadsheets in a familiar interface. Open compatible Microsoft Office files to move everyday work across easily; it does not fix Access combo box settings or replace Access database forms.

Organize customer names, states, and cities in WPS SpreadsheetsOpen and edit compatible Microsoft Excel XLSX filesUse a familiar interface for everyday office tasksGet started with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Access combo box save the state instead of the customer name?

Its Bound Column likely points to the state column. In Design View, select the combo box and check Bound Column on the Property Sheet's Data tab. Set it to the position of the customer-name column in the Row Source.

Does Access count combo box columns from zero or one?

The Bound Column property uses one-based numbering, so 1 means the first column. The Column property used in code is zero-based, so Column(0) refers to the first column.

Can I save a hidden column while displaying another value?

Yes. Set Bound Column to the column you want to save, then use Column Widths on the Format tab to hide it with a width of 0. The combo box displays the first visible column when collapsed.

How can I display the state, customer name, and city together after selection?

Add a calculated display column to the Row Source that concatenates those fields. Set Column Count to include it, then use Column Widths to make it the first visible column while keeping the customer-name column bound.