TRIMLEFT( )
Removes the leading blanks from a specified string.
Syntax
TRIMLEFT(str)
Arguments
str
The string from which to remove the leading blank characters.
Returns
A string with all leading blank characters removed.
Example
The following example concatenates a literal string with each value in the customerName data field. TRIMLEFT( ) removes all blank characters preceding the customerName value so that there are no extra blank characters between the literal string and the customerName value.
"Customer name: " & TRIMLEFT([customerName])