MS Access Trim() Function

Remove leading and trailing spaces from a string

Definition and Usage

The Trim() function removes both leading and trailing spaces from a string.

Syntax

Trim(string)

Parameter Values

Parameter Description
string Required. The string to strip both leading and trailing spaces from

Technical Details

Works in: From Access 2000