RTrim, RTrim$ Functions

---

Named Arguments

No

Syntax

RTrim(stringexp)

stringexp

Use: Required

Data Type: String

A valid string expression.

Return Value

RTrim returns a variant of subtype String; RTrim$ returns a string.

Description

Remove any trailing spaces from stringexp.

Rules at a Glance

• If stringexp contains a Null, RTrim returns Null.

• RTrim returns a variant of subtype String.

• RTrim$ returns a String data type.

Programming Tips and Gotchas

Unless you need to keep leading spaces, you should use the Trim function, which is the equivalent of RTrim(LTrim(string)), thereby clearing both leading and trailing spaces in a single function call.

See Also

LTrim Function, Trim Function