display beyond the length of the combo box

R

Robert Mark Bram

Hi All!

I know how to get a drop down combo box to display multiple fields when
selected, but how do I get it to display those multiple fields beyond the
length of the combo box itself?

Thanks for any advice!

Rob
:)
 
S

Steve Schapel

Rob,

Experiment with the Column Widths and List Width properties of the combobox.
 
A

Allen Browne

The additional fields can only be displayed when the combo is dropped down.

In Form view (not datasheet or continuous), you could add some extra text
boxes beside the combo, and set their Control Source to:
=[Combo1].[Column](1)
and so on.

In a continuous form/datasheet, you could use a query as the RecordSource.
Include the combo's lookup table, and you can then display the other fields
in the form. Make sure you use an outer join (unless the combo's bound
column is required), and set the Locked property of the lookup table's
output fields to No.
 
Top