How do I remove blank spaces in a text field?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Admin Matt - 17 Nov 2005 01:26 GMT

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.

Reply to this Message

David S - 17 Nov 2005 01:51 GMT

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

Reply to this Message

Admin Matt - 17 Nov 2005 15:13 GMT

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

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

Reply to this Message