Combo box not displaying many columns

  • Thread starter Thread starter Beth McLaren
  • Start date Start date
B

Beth McLaren

How do I take my form that contains numerous combo boxes and make it such
that you can select a selection from the combo and make it show all columns?
Is this possible? How do you also make the combo box larger to see all
columns to make a section?
Thanks!
Beth
 
If you mean you want the combobox to display all the columns after you have
selected an item and moved off the combobox, then you cannot do this.

You can concatenate (add together) all the columns and have that displayed
OR
you can add textbox controls to the form and have them show the value of the
various columns by setting each control's source to something like
=[NameOfCombobox].Column(1)
Where the number one is the column position of the column you want to display
a value from. The number is one less than the column because the columns
numbers are zero-based. That is the first column is numbered 0, the second
column 1, etc.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Beth

An example would help us visualize your situation.

Otherwise, it's tough to tell whether making it "show all columns" is just
another way of saying "show me the record"...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top