Combo box

  • Thread starter Thread starter Rpettis31
  • Start date Start date
R

Rpettis31

I have been trying to have a combo box display both columns; the box is bound
to an item master table, I am just trying to display the item and the
description.
They appear in the drop down but only the item holds in the box.
 
It will only display the 1st column with a width greater than 0

You could place an unbound text box next to the combo and set the source to
=comboname.column(2)
or what ever column you want to display

This does not affect the bound column (the data which is stored)
 
Wayne:

Its perhaps worth noting that Column(2) is the third column, the Column
property being zero-based.

Also its worth mentioning that the bound column does not necessarily
determine the data stored, but rather the value of the control. I suspect
that you are right in the context of this thread, but it could be an unbound
control of course. When the OP says 'the box is bound to an item master
table' I think they in fact mean that its RowSource draws on that table.
Reading between the lines my guess is that it is probably bound to a foreign
key column in a referencing table, but it might not be.

Ken Sheridan
Stafford, England
 
I use a calculated field to display more than one column.
SELECT [Change Requests].[ID], [Change Requests].[Something] & " - " &
[Change Requests].[SomethingElse] FROM [Change Requests];

Column Widths -
0"; 1.5"
 
Back
Top