Combo box bound column

[Louisa Ray]

How do I get the combo box to display the values from column 2 in a table? I
am trying to get it to show menu items when the drop down arrow is clicked,
but it is showing the record numbers from column 1 (ie 1,2,3). I am sure this
is something really easy, but can't figure this out.

Thanks for any help.

 

[Ron2006]

In the format tab of the properties for the combo box.


Number of columns should be the number of columns in the inderlying
query/table
column widths should be the width of each of the colmns as they would
show when you force the dropdown.
in this instance you would probably have: 0";1"

0 length of any column that you do NOT want to see and the appropriate
length for any that you want to see.
The first visible column is the one that will show after you have
selected an entry.

The bound column on the data tab is the column of the data that will
be saved or available when you use the
me.comboxname object in any instrunctions.

Ron

 

[Al Campagna]

Louisa,
A combobox will always "display" the first "visible" column.
For example, if you had just two columns...
NoOfColumns = 2
ColumnWidths = 0"; 1" 'hides the first column

If the combo is bound to a table field, the column one value will be
applied to that field, but the combo will "display" the column two value.
It also allows the user to make a selection using the column two values.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Damon Heron]

And don't forget that the columns are zero-based, so if you are referring to
a column, start your count with "0".
So combobox.column(2) is really the third column in the underlying source.

Damon