How do I remove blank spaces in a text field?

A

Admin Matt

I have a large access file that has a text field with data in it of various
length that some how got spaces of various lengths at the very end of each
entry. I need to remove those spaces. What is the easiest way to do a query
to remove those spaces? Thank you for any help.
 
D

David S via AccessMonster.com

So long as there are no space at the beginning of the text that you want to
keep, I'd use the TRIM function in an update query, or a SELECT query using
the TRIM function that is then used elsewhere...
 
A

Admin Matt

Thank you David, that worked. For anyone wondering the exact steps I took
they are as follows:

1. Open up the Access file
2. Go to Queries
3. Select Create query in Design view
4. Select the proper table
5. Select the field you want to have the extra spaces removed from
6. On your top menu bar select Query Type and choose Update Query
7. Below in the Update To field type in Trim[Field Name]
8. Click on Run in the top menu
 
Top