How do I remove blank spaces in a text field?

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

Guest

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.
 
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...
 
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
 
Back
Top