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.

Example

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