Access: RTrim Function

In Access, the RTrim function returns a copy of a string with trailing spaces removed.

The syntax for the RTrim function is:

RTrim ( string )

The string argument can be any string expression. If string contains Null, Null is returned.

Example

RTrim("  WebCheatSheet " )        returns " WebCheatSheet" RTrim("tutorials ")                      returns "tutorials" RTrim(" articles")                       returns " articles"

VBA Code

Dim MyString, RTrimString MyString = " Access " RTrimString = Trim(MyString)

This example uses the RTrim function to strip trailing spaces from a string variable. Now the MyString variable would contain the value " Access".

SQL query

You can also use the RTrim function in a query.

SELECT RTrim([ItemDesired]) AS Expr1 FROM Orders