TRIMRIGHT( )
Removes the trailing blanks from a specified string.
Syntax
TRIMRIGHT(str)
Argument
str
The string from which to remove the trailing blank characters.
Returns
A string with all trailing blank characters removed.
Example
The following example concatenates each value in the Comment data field with a semicolon, then with a value in the Action data field. TRIMRIGHT( ) removes all blank characters after the Comment value so that there are no extra blank characters between the Comment string and the semicolon.
TRIMRIGHT([Comment]) & "; " & [Action]