How can I control what is displayed by a combo box selection?

[Gordon Padwick]

I have a combo box in Access 2003 that contains three columns from a table. The combo box correctly lists the contents of those three columns. I have one column specified as the bound column, so when I select a row in the combo box’s list, the combo box displays just that the information in the one bound column. Instead, I would like the combo box to display the concatenated values of the three columns. Is there a way to do that?

Thanks for any suggestions.

Gordon Padwick

[gnawoncents]

Are you running any code based on the combo box's value? If not, why not base the combo box recordsource on the concatenated values from the start?

If, for whatever reason, that won't work for you, you can set up the concatenated value as the first column in your record source and set the combo box properties like this:

Column Count: 4
Column Widths: 0.0007";1";1";1"

Set the last three column widths to whatever length you need, but keep the first so small it can't be seen (don't use zero (0) or it won't work).

This will show the last three columns when you are selecting, but only show the first column after selection.