Don't see values in drop down list

[lewis33]

Got a strange (but true) problem. I have a couple of combo boxes. Each combo box is a multi-column and all works
EXCEPT THAT

Whenever I choose a value in the drop down list, (the drop down list then holds the value) but it only displays the first column in the multi-column drop down.

For example, I select
OREGON | CROOK COUNTY

When I click off, only Oregon shows - if I hit the drop down list OREGON | CROOK COUNTY shows up again. Must be doing something wrong in the properties of the combo box.

 

[nealvenables]

Check the "Column Count" and "Column Widths" properties.

"Column Count" should probably be set to 2.

 

[kpal29]

I don't think changing the column count or width will allow you to show both fields. You should go to the properties, data tab and open the query behind the dropdown.

Add another field there and concatenate the two fields values you want to show together.

Then change the column count and widths accordingly.

ex. fields: color order
values: yellow one
blue two

In the query grid, in a new column type:
name: color & "," & blue

In the column count set it to 4 (assuming the fields are ID, Color, Order, Name
Set column widths to : 0";0";0";1"

This will give you both values in the box.

 

[lewis33]

Mrrs Nealy and Kpal29,
Thanks very much for your ideas and input. I do have the column counts set right. Looks like combo boxes don't display (for whatever reason) all columns once a value is selected. I'll go ahead with the concatenating the values for sake of display and set the column widths to 0" on the columns I don't want to display but want to bind the values.

Great input guys... got to be creative with some of these things I objects it looks like.