Combo box column display

[stephen81]

I have a combobox on a form, with 2 columns. The first column is ID and the second is Name. The ID column is the bound one.
When I set the first column width to 0 so I can only see the second column and select a value, the second column is displayed as my choice in the combobox. If I change the column width so I can see both columns in the dropdown list, only the first column is displayed once I have selected the value.
Does anyone know why this is? I am not changing the bound column. I would really like to be able to show both columns, or failing that, just the second column in the box with both in the drop down list.

 

[Mile-O]

The combobox can only show one column; it contains the any other fields, too.

The value of the first visible column is displayed in the combobox.

 

[stephen81]

OK. Thanks.

 

[elsandalos]

Hi all,
I want to do the same thing.

1. I've got ProjectID and ProjectName.
2. I've got a combo box which stores the ProjectID in the field
3. I want to display both columns in the drop-down
4. I want ProjectName to be displayed when i've left the field

seems that you can either do 3 or 4, but not both together. Odd - I could understand the problem if i wanted to display both columns in the field when i've left it, but i don't need that.

Looks like the only way to achieve this is to set up the combo as in 3, and add a static field on the form which displays the ProjectName.

Any other ideas?

El.

 

[stephen81]

That might be the only way of doing it. I just settled for only showing the second column in my combo box.