Display columns in combo box

torttion
torttion used Ask the Experts™
on
I have a combo box with three columns.  The first is hidden (0 width), the other two are visible.  When I pull down down on the combo box to make a selection, I can see both visible columns but when I select one and release, only the first column remains visible in the box.  How can I fix this?

PS, I'm using access 2007
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:
by default, combo box will display only a single column from the row source.

you have to do some trick to accomplish this.
* adding a textbox (txtDisplay), over the combo box
* in the  after update event of the combo box, place this codes
   me.txtDisplay.setfocus
   me.txtDisplay=me.cboCourse & "|" & me.cboCourse.Column(1) & "|" & me.cboCourse.Column(2)

Author

Commented:
Works beautifully, thanks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial