Combo Box

[Robert Raley]

Access 2003

I am using a combo box with 2 columns. I store the data from the first
column in a table. When I am viewing the form I am now viewing the data
from Column 1 in the field. I would like to view the name in field.

Thanks

Bob

 

[Mark M]

Look at the properties of the combo box in the form's design view. Make
sure it's set for two columns, and make the column widths 0" and 1" to hide
the first column and show the second.

 

[Robert Raley]

I am sorry. I am happy with the combo drop down. What I want to see when I
am reviewing the form is the City name in the field not the city id number.
The id num is stored in the table.

hope I have been clearer now.

Thanks

Bob

 

[fredg]

I am sorry. I am happy with the combo drop down. What I want to see when I
am reviewing the form is the City name in the field not the city id number.
The id num is stored in the table.

hope I have been clearer now.

Thanks

Bob

You were clear the first time.
And the answer you received was correct.
Set the Column widths property of the combo box to:
0";1"
Set the Bound column property to 1
Set the column count property to 2

The first column (hidden) is the ID number and will be stored in the
table.
The second column (the name column) will be what you see in the combo
box.

 

[Mike Painter]

Access 2003

I am using a combo box with 2 columns. I store the data from the
first column in a table. When I am viewing the form I am now viewing
the data from Column 1 in the field. I would like to view the name
in field.

The correct answer is that you should relate the table containing the ID and
the table which contains the name, address, phone, etc.
Use that query in your forms and reports. Show the name from the Name table
and don't show the ID field from the "main" table.