Unbound Combo Box Question

[wilderfan]

I have placed an unbound combo box on a form.

This combo box has 4 columns, but only 3 of the columns are visible to the user. The "invisible" 4th column is the bound column.

After making a selection and moving onto the next control on the form, the combo box displays the previously "invisible" 4th column value (which happens to be a primary key id #).

I would prefer for the user to continue to see the 3 visible fields rather than the bound column value.

There must be a way to do this, but I'm spinning my wheels.

Any suggestions ?

 

[Rick_A]

Set the width property of the combobox so that the column with the id has a width of zero. So the width property of the combo box should look something like:
0";1";1";1"

 

[wilderfan]

The dropdown list works fine with those settings.

But after the user selects a record and moves onto the next control, the combo box shows the bound column value only.

 

[asad.saeed]

can you attached the sample?

 

[vbaInet]

Make the bound column the first column and use the column widths provided by Rick A.

 

[wilderfan]

The 4 columns are set up based on the measurements suggested.

However, I did make 1 error in describing what I see after selecting a record.

The item which is visible after exiting the combo box is not the invisible bound column (column 1). Rather, it is the item from column 2 (or the 1st of the 3 visible columns).

Does this mean that Access allows the contents of only 1 column to be visible after the user exits a combo box control?

 

[vbaInet]

Does this mean that Access allows the contents of only 1 column to be visible after the user exits a combo box control?

Correct .