strip spaces (Office XP)

[trodat]

Hi, is there a way to strip a space from the front of data. in my fields i have (space)persons name in some but not all of my fields - makes my labels in my mail merge look a bit odd!



<img src=/S/flags/NewZealand.gif border=0 alt=NewZealand width=30 height=18>

[HansV]

You can use the LTrim or Trim function in a query based on the table, and use the query as data source for the mail merge. The LTrim function removes all leading spaces, and the Trim function removes all leading and trailing spaces from a string value. (As you might guess, there is also an RTrim function.) In the query, create one or more columns like this, of course with the appropriate field name substituted:

TrimmedName: Trim([NameField])

If you would like to remove the spaces permanently, create a query based on your table and change it into an update query (Query | Update Query). In the "Update to" line under the NameField field, enter

Trim([NameField])

and repeat for other fields you want to trim, if applicable. Then run the query (Query | Run). You will be prompted that you are about to update ... records. Confirm.

[trodat]

Thank you once again!