eliminate spaces after a text field

[Cam]

Hello,

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

 

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