access 2003

[Guest]

how can I get the combo box to show more than the bound column on a form?
What is the use of having choices if it only brings over a piece of
information?

 

[Guest]

A combo box will normally display columns whose width is not set to zero,
when in the dropped down mode. However, when not dropped down, a combo box
will only display the first visible column, which may or may not be the bound
column (it apparently is in your case).

You can use the idea of concatenation to display additional fields in a
combo box when it is not in the dropped down state. An example is shown in my
tutorial here:

Combo box to find a record
http://www.access.qbuilt.com/html/find_a_record.html


See paragraphs 14-16.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Granny Spitz via AccessMonster.com]

how can I get the combo box to show more than the bound column on a form?

Set the column count to a higher number and set the column widths to the
length of each column in inches:

0";0.5";2"

will hide the first column (probably the primary key), show half inch of the
2nd column, and show 2 inches of the third column.