In a dropdown list I get the ID #, I need the actual information

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a drop down list in a combo box, I need the choices to be one of the
fields and not the ID for that field. How do I make it show the fields?
 
Go to the Properties of the combo box. You can specify how many columns
there are in the combo box, and which column(s) you want to have displayed.
 
Ok, if I put in three on the column count, I can get all three, if I put one,
it just gives me the ID #, which control do I need to go to, to tell it I
want the 3rd column to be the one to show?
 
The Bound Column property

Keri Lyn said:
Ok, if I put in three on the column count, I can get all three, if I put one,
it just gives me the ID #, which control do I need to go to, to tell it I
want the 3rd column to be the one to show?
Click to expand...
 
You use the Column Widths property.

Separate the widths with semi-colons. If you don't want a particular column
to display, set its width to 0. If you want the column to have the default
width (1", or 2.54 cm), put nothing. So if you wanted the first column to be
hidden, the second column to get the default width and the third column to
be 2 inches wide, you'd put 0;;2"
 
I have put in that I want one column and the bound to column is number three.
In the drop down list it is still showing the ID# which is in column #1. Do
I need to save something first? I thank you for your patience, this is my
first time working with Access. I am sure though that I have the bound to
column set as 3 etc.
 
Thank you very much!!!!!

Douglas J Steele said:
You use the Column Widths property.

Separate the widths with semi-colons. If you don't want a particular column
to display, set its width to 0. If you want the column to have the default
width (1", or 2.54 cm), put nothing. So if you wanted the first column to be
hidden, the second column to get the default width and the third column to
be 2 inches wide, you'd put 0;;2"
Click to expand...
 
Just to make sure we're not confusing Keri Lyn here...

In addition to what columns are displayed, you can set a column to be the
"bound" column. That means that's the value that will be returned when you
refer to the combo box.

The bound column does not have to be visible. You set the visibility through
the Column Widths property (as I've explained elsewhere in this thread), you
assign which column is bound to the control through the BoundColumn
property.
 
Back
Top