Getting column 2 to display in combobox when selected

[Spidey3721]

I have a combo box with two columns showing. the first column is a number
and the second is a description of that number. I want the description to
show in the field once something is selected, but it keeps showing the
number only. The only way I've found so far is to switch the columns, which
I'd rather not do....

I thought that changing the bound column would do it, but it doesn't seem
to...

 

[Cheryl Fischer]

Set the Column Count to: 2
Set Column Widths to: 0";1"

Change the 1" to whatever display size you want for the value in your second
column

hth,

 

[Spidey3721]

I want both of the columns to show when I pull down on the combobox, but I
want the 2nd column to display in the field after selected...

Right now I have column count =2, so I can show both the number and the
description in the pulldown
I have the widths set for each column so I can see both, .5", 2.5"

The number field keeps showing after the selection is made - I want the
description to show WITHOUT having to switch the order of the columns (by
making the number the second column and the description the first column)

 

[Cheryl Fischer]

From the Access Help file: "In a combo box, the first visible column is
displayed in the text box portion of the control."

Therefore, if you want the second column of your combo box to be the
displayed value on your form after selection of a value, you will either
have to make the first column 0" in width or change the order in which the
columns are displayed.