Combo Box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tiffany Walker - 31 May 2007 19:53 GMT

We have a combo box set up with 2 columns but when we click to make a
selection only the first column is redisplayed. How do we get column 2 to be
displayed?

Reply to this Message

fredg - 31 May 2007 20:14 GMT

> We have a combo box set up with 2 columns but when we click to make a
> selection only the first column is redisplayed. How do we get column 2 to be
> displayed?

Do you mean after you have selected a value?
You can't.
A Combo box will only display the first column whose width is greater
than 0.

If you need to 'see' both columns after selection, add an unbound text
control to your form.
Set it's control source to:
=[ComboName].Column(1)
Where (1) is the number of the column you wish to display (Combo
boxes are zero based so column(1) is the second column.

Signature

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

Reply to this Message

Douglas J. Steele - 31 May 2007 20:15 GMT

A combo box only shows a single column when it isn't opened. Are you saying
you want column 2 to show instead of column 1? If so, go in and set the
ColumnWidths to 0 (or 0;1, where you can replace 1 with whatever width you
want). Just make sure that the ColumnCount property is 2.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> We have a combo box set up with 2 columns but when we click to make a
> selection only the first column is redisplayed. How do we get column 2 to
> be
> displayed?

Reply to this Message