Trouble with displaying more than 1 column in a combo box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Novel - 04 May 2007 00:57 GMT

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

Reply to this Message

fredg - 04 May 2007 01:32 GMT

> Hi...can anyone please help. i looked every where but still cant find an
> answer.
[quoted text clipped - 3 lines]
> title.
> Thanks Novel

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.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

Novel - 04 May 2007 10:45 GMT

YOU ARE FANTASTIC THANK YOU SO MUCH.
THIS IS EXACTLY WHAT I WANTED

> > Hi...can anyone please help. i looked every where but still cant find an
> > answer.
[quoted text clipped - 16 lines]
> column. Now the Combo will display it's bound value and the text
> control the associated name value.

Reply to this Message