Combo Box after selection

[Steve via AccessMonster.com]

I have a combo box with 4 columns that is bound by the first column, and
stores the selection in the underlying table - the combo box works fine, but
after the user makes their selection, all that remains in view is the item
selected from the first column.

My Combo Box looks like this:

CODE DEPT EMPLOYEE POSITION
==== ```====~~~==========~~=======
06-31~ Acctg~ Smith~~~ Clerk

.... but after the user selects this choice, they only see in the box:

06-31

I would like a message in a control showing what they selected - I believe
that's possible, but I forgot how to do it

 

[Duane Hookom]

A combo box will only display one column. You can either concatenate columns
together in the Row Source of the combo box or add text boxes with control
sources like:
=cboMyCombo.Column(1)

Column numbering is zero based.

 

[fredg]

I have a combo box with 4 columns that is bound by the first column, and
stores the selection in the underlying table - the combo box works fine, but
after the user makes their selection, all that remains in view is the item
selected from the first column.

My Combo Box looks like this:

CODE DEPT EMPLOYEE POSITION
==== ```====~~~==========~~=======
06-31~ Acctg~ Smith~~~ Clerk

... but after the user selects this choice, they only see in the box:

06-31

I would like a message in a control showing what they selected - I believe
that's possible, but I forgot how to do it

A combo box only shows all of it's columns (those with a column width
greater than 0") when you click on the drop-down arrow.
After selection it will show only the first column that has a width
greater than 0"

You need to add additional unbound text controls.
Set the control source to
=ComboName.Column(1)
=ComboName.Column(2)
etc.
Note: Combo Boxes are Zero based, so Column(1) is the 2nd column.

 

[Steve via AccessMonster.com]

Fred,
Thanks - I've since come up with a work-around, but I still have an issue - I
created an unbound text box with a message string that captures and displays
the values - there are some forward slashes I used in my string, but when
nothing has been selected, it just shows:

/ /

in the text box - how can I get the control to disappear when there's nothing
in the combo box, or better yet display a message - any suggestions ?

Steve

I have a combo box with 4 columns that is bound by the first column, and
stores the selection in the underlying table - the combo box works fine, but

[quoted text clipped - 13 lines]

I would like a message in a control showing what they selected - I believe
that's possible, but I forgot how to do it

A combo box only shows all of it's columns (those with a column width
greater than 0") when you click on the drop-down arrow.
After selection it will show only the first column that has a width
greater than 0"

You need to add additional unbound text controls.
Set the control source to
=ComboName.Column(1)
=ComboName.Column(2)
etc.
Note: Combo Boxes are Zero based, so Column(1) is the 2nd column.

 

[Duane Hookom]

Change your "work-around" to the methods described.

--
Duane Hookom
MS Access MVP

Fred,
Thanks - I've since come up with a work-around, but I still have an
issue - I
created an unbound text box with a message string that captures and
displays
the values - there are some forward slashes I used in my string, but when
nothing has been selected, it just shows:

/ /

in the text box - how can I get the control to disappear when there's
nothing
in the combo box, or better yet display a message - any suggestions ?

Steve

I have a combo box with 4 columns that is bound by the first column, and
stores the selection in the underlying table - the combo box works fine,
but

[quoted text clipped - 13 lines]

I would like a message in a control showing what they selected - I
believe
that's possible, but I forgot how to do it

A combo box only shows all of it's columns (those with a column width
greater than 0") when you click on the drop-down arrow.
After selection it will show only the first column that has a width
greater than 0"

You need to add additional unbound text controls.
Set the control source to
=ComboName.Column(1)
=ComboName.Column(2)
etc.
Note: Combo Boxes are Zero based, so Column(1) is the 2nd column.