Updating with Access

Updating with Access

Q: Is there a way to trim leading and trailing spaces from an Access field by doing an update query or some other function? I tried updating NewField with the expression: Trim([OldField]) and all it does is remove the equal sign and insert the text "trim([OldField])" in the field I'm updating.

A: I just used this one and it worked fine, trimming excess spaces at the beginning or end but not in the middle:

UPDATE [Text] SET [Text].newtext=Trim([oldtext]);

Text is the table. Oldtext and Newtext are the two fields.

To subscribe the NICAR-L discussion list, follow the instructions at www.ire.org/membership/subscribe/nicar-l.html.