Trouble with displaying more than 1 column in a combo box

N

Novel

Hi...can anyone please help. i looked every where but still cant find an
answer.
I have a combo box that displays a standard no. and standard title.when the
user selects an option from the drop down menu.access will only display one
of the columns.i would like to be able to display both the standard no. and
title.
Thanks Novel
 
F

fredg

Hi...can anyone please help. i looked every where but still cant find an
answer.
I have a combo box that displays a standard no. and standard title.when the
user selects an option from the drop down menu.access will only display one
of the columns.i would like to be able to display both the standard no. and
title.
Thanks Novel
Click to expand...

Sorry! After selection, a combo box will only display one column, the
first column whose column width is greater than 0".

Assuming the bound column of the combo box is column 1, you can add an
unbound text control to your form.
Set it's control source to:

= ComboBoxName.Column(1)

Since Combo boxes are zero based, column(1) is actually the 2nd
column. Now the Combo will display it's bound value and the text
control the associated name value.
 
Top