Using the LEN Function
In this tutorial you will learn how to use the LEN Function.
The LEN function returns an Integer containing the length of characters in a string.
=LEN( string )
string the value you wish to count
In this example we will work with a Name.
The result is 12.
The results using a Query would be
In a Form you could set the Default Value of a Textbox to
In a Form add a TEXTBOX control and rename it "txtLen", then you could add the following in the Load Event.
Private Sub Form_Load()
txtLen = Len("Richard Rost")
Access Expert 14
See this FREE Tip on Len and many others.
See this Blog Post on the Len function.
You can find more about this by searching the website.
By: Alex Hedley
Click here to sign up for more FREE tips