Access: Len Function

In Access, the Len function returns the length of the specified string.

The syntax for the Len function is:

Len ( string )

The required string argument is any valid string expression. If the argument to Len is Null, the function returns a Null.

Example

Len ("access")                         returns 6 
Len ("webcheatsheat.com")      returns 17 
Len ("hello world")                   returns 11

VBA Code

Dim MyNumber As Long 
Dim MyString As String 
MyString = "WebCheatSheet.com" 
MyNumber = Len(MyString) 

This example uses Len to return the number of characters in a string. Now the MyNumber variable would contain the value 17.

SQL query

You can also use the Asc function in a query.

SELECT Len([ItemDesired]) AS Expr1 
FROM Orders