MS Access Len() Function

Return the length of a string:

SELECT Len("SQL Tutorial") AS LengthOfString;

Definition and Usage

The Len() function returns the length of a string.

Len(string/varname)

Parameter	Description
string/varname	Required. The string or variable name to return the length for

Works in:	From Access 2000

Return the length of the text in the "CustomerName" column:

SELECT Len(CustomerName) AS LengthOfString
FROM Customers;