display beyond the length of the combo box

  • Thread starter Thread starter Robert Mark Bram
  • Start date Start date
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
:)
 
Rob,

Experiment with the Column Widths and List Width properties of the combobox.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Showing combo box box that's not an option in its drop-down list 5
Combo box begining row in dropdown 6
Combo box choice outcome 2
Cascading Combo Box Questions 7
combo box data type 1
Access Combo Box display 1
How to get Combo Box 'always' display Multiple Fields 5
combobox question 3

Back
Top