Combo Box - Display other than column 1

[David]

Hi,

After user selection, how do I display a column other than column 1?

I display 4 columns: Level 1, Level 2, Level 3, and Description. The user
is selecting the Description field, but Levels 1-3 are there for
informational purposes.

I am able to update the table correctly, as Description (field 4) is the
bound column.

However, the data which populates the combo box field is column 1 (Level 1).

How do I have column 4 populate the combo box?

Thanks.

 

[Allen Browne]

To store column 1, but display column 4 of the combo, set its properties
like this:
Column Count: 4
Column Widths: 0;0;0;1"
Bound Column: 1

 

[Jeff Boyce]

Open the form in design view.

Select the combobox control.

Open the Properties (right-clicking on the control is a short-cut way).

Find the property that deals with column widths ... and set all that you
DON'T want to see to 0 (zero).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[David]

I may not have been clear with what I am trying to do:

1. I want to display 4 columns when the user clicks the down arrow: Level 1,
Level 2, Level 3, and Description.

2. Once the user selects a row, I want the data in the Combo box to contain
the data in the Description column. The problem is this: The data displayed
in the Combo box is from Column 1 (field name Level 1).

Thanks.

 

[Allen Browne]

So you want to show all 4 columns, but bind it to the 4th column?

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

 

[David]

Close...

I have the binding down fine...
What I want is that after I select a row, the bound column (column4) appears
in the combo box. Currently, column1 (not column4) appears on the combo box.

 

[Bob Quintal]

Hi,

After user selection, how do I display a column other than column
1?

I display 4 columns: Level 1, Level 2, Level 3, and Description.
The user is selecting the Description field, but Levels 1-3 are
there for informational purposes.

I am able to update the table correctly, as Description (field 4)
is the bound column.

However, the data which populates the combo box field is column 1
(Level 1).

How do I have column 4 populate the combo box?

Thanks.

You will need to code the combobox's On Got Focus and On Lost Focus
events to set the column widths to 0 for the first 3 columns, when
the combo box does not have the focus.

 

[Allen Browne]

The first non-zero width column is always what the combo displays, so if you
want the Description to show when the combo is not dropped down, it will
have to be the first non-zero-width column. Change the RowSource to a query
where the Description column is the first field.

If that is not suitable, you could add a text box beside the combo, with
ControlSource of:
=[Combo99].Column(3)
The text box will then show the Description column, while the combo shows
its first non-zero width column as normal. (Note that the first column is
number zero.) This assumes Form view (not Continuous or Datasheet.)