Find + delete from text field

[walter]

I have a table I would like to change the values of the
primary key.

This currently contains entries such as "China ", where
the spaces are note desirable.

How can spaces be removed from values in a field of type
text?

In this case the result would turn the above into "China".

N.B. I am sure that doing this will still maintain unique
values for the primary key.

Regards,

Walter

 

[John Vinson]

I have a table I would like to change the values of the
primary key.

This currently contains entries such as "China ", where
the spaces are note desirable.

How can spaces be removed from values in a field of type
text?

Run an Update query updating the field to

Trim([fieldname])

If there are other tables linked by this field, you will need to set
Cascade Updates on all the table relationships to update "China " to
"China" in the linked tables as well.