eliminate spaces after a text field

C

Cam

Hello,

I am designing in query and there are spaces after text field. How do I
delete the spaces after? Thanks
 
B

BruceM

Try something like:
NewField: Trim([YourField])

To remove trailing spaces only (not leading spaces):
NewField: RTrim([YourField])

Spaces in the middle of the field will not be affected.

Use your actual field name in place of YourField. Use whatever you like in
place of NewField.
 
Top