Help! data in field differs from that in text box

[Allan Murphy]

Michelle

If you are using a combo box, then in the properties set the column width to
0;x

0 hides the first column but stores that value in your table.
x is the maximum width that you want to display your Country

By doing the above you will be able to store the id and display only your
Country.

 

[Guest]

Hi, I'm using MS Access 2000 and have found that though I've created a text
box that includes the info I want in the field, this does not appear in the
field.
I'm using a link from a table that has 2 columns-i.d (the primary key)
and country\ethnic group. When I access the text box, country names appear
but the info that actually appears in the field is the i.d. which is
meaningless-I need country\ethnic group to also appear in the field. Can
someone please help?

 

[SusanV]

Hi Michelle,

Change the Bound Column property to 2

 

[BruceM]

It would have to be a combo box. In addition to Bound Column set to 2, you
would need to set the column count set to 2 and the column widths 0;1" (or
whatever width you choose). A text box does not have a bound column
property. Another option would be to place the country in another text box.
If you are going to be selecting the country from a list, a combo box is a
good way to go. If you are adding a new record and if the PK is
automatically generated there is probably no need to see the ID field at
all.

 

[SusanV]

Doh! Too early - my bad...

It would have to be a combo box. In addition to Bound Column set to 2,
you would need to set the column count set to 2 and the column widths 0;1"
(or whatever width you choose). A text box does not have a bound column
property. Another option would be to place the country in another text
box. If you are going to be selecting the country from a list, a combo box
is a good way to go. If you are adding a new record and if the PK is
automatically generated there is probably no need to see the ID field at
all.