Removing Trailing Spaces

[SmirnoffBlu]

I would like to know how I can remove all the trailing spaces from variable length data in a text field using the Right$ function.

 

[Jacqui3]

This is from the online help - hope it helps!
LTrim, RTrim, and Trim Functions Example
This example uses the LTrim function to strip leading spaces and the RTrim function to strip trailing spaces from a string variable. It uses the Trim function to strip both types of spaces.

Dim MyString, TrimString
MyString = &quot; <-Trim-> &quot; ' Initialize string.
TrimString = LTrim(MyString) ' TrimString = &quot;<-Trim-> &quot;.
TrimString = RTrim(MyString) ' TrimString = &quot; <-Trim->&quot;.
TrimString = LTrim(RTrim(MyString)) ' TrimString = &quot;<-Trim->&quot;.
' Using the Trim function alone achieves the same result.
TrimString = Trim(MyString) ' TrimString = &quot;<-Trim->&quot;.

 

[Bigpapou]

Why don't you start from the Left$ instead of the Right$.

Like this: Left(Variable, Len(Variable))
This should give you your variable... and only your variable.

I did not test this so... this is only theory.