Fix an Access Combo Box Saving the Wrong Column
Question details
The user needs an Access combo box to save the customer name while displaying the state, customer name, and city.

- 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.
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.
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.
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.
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.
On the Data tab, set Bound Column to 1 so the combo box stores CustomerName, the first column in the query.
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.
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 existing customer-name column
Use this quicker option if saving the name is the priority and a combined label is not required after selection.
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.

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.




