Access: LTrim Function

In Access, the LTrim function returns a copy of a string with leading spaces removed.

The syntax for the LTrim function is:

LTrim ( string )

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


LTrim(" WebCheatSheet ")       returns "WebCheatSheet " 
LTrim("tutorials ")                   returns "tutorials "
LTrim(" articles")                    returns "articles"

VBA Code

Dim MyString, LTrimString 
MyString = " Access "
RTrimString = Lrim(MyString)

This example uses the LTrim function to strip leading spaces from a string variable. Now the MyString variable would contain the value “Access “.

SQL query

You can also use the LTrim function in a query.

SELECT LTrim([ItemDesired]) AS Expr1 
FROM Orders


Leave a Reply

Your email address will not be published.