Access LTrim Function

Last updated: August 26, 2026.

The LTrim function removes space characters from the left end of a string.

Syntax

LTrim(string)
ArgumentDescription
stringText expression to trim

Examples

LTrim("   WebCheatSheet")
CleanCode: LTrim([ProductCode])
SafeText: LTrim(Nz([Notes], ""))

LTrim returns Null for Null input. Use Trim when spaces should be removed from both ends.

See Microsoft’s Access function reference for related expression functions.

admin

admin

Leave a Reply

Your email address will not be published.