Access: RTrim Function

In Access, the RTrim function removes trailing spaces from a string.

The syntax for the RTrim function is:

RTrim ( text )

Text is the string that you wish to remove trailing spaces from.

For example:

RTrim ("Tech on the Net ") would return "Tech on the Net"

RTrim (" Alphabet ") would return " Alphabet"

VBA Code

The RTrim function can be used in VBA code. For example:

Dim LResult As String

LResult = RTrim (" Alphabet ")

The variable LResult would now contain the value of " Alphabet".

You can also use the RTrim function in a query.