Combo box Column setings

[Edward]

Hi everybody,
I have a combobox in a form which has two columns after i make a selection
only the content in the first column shows in combo , how can I change the
combobox setting that will show both columns after selection ( currecly it
shows both columns only when I open the dropdown not afer I make a selection)
Thanks

 

[Jeff Boyce]

Edward

That isn't how Access' comboboxes work... you can't.

Now, if you'd like to see what is/was in the second column after the
combobox selection is made, that's absolutely possible (just not the way you
asked it to be done).

Create a new textbox on your form. Do not bind it to any field.

In the AfterUpdate event procedure of the combobox, add something like:

Me!txtYourNewTextbox = Me!cboYourCombobox.Column(1)

The .Column(n) is zero-based, so your second column in the combobox is
..Column(1).

This will display the value in the second column of the combobox in the new
textbox (use your name, not mine!) after the selection is made in the
combobox.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Douglas J. Steele]

It's not possible.

Your options are to have a text box that displays the other value, or to
have the combo box display a field that concatenates the two values
together.