Daffodil Computers Ltd.

Office Suite Tutorial => Microsoft Office Access => Topic started by: bbasujon on August 15, 2012, 05:16:26 PM

Title: Microsoft Access Function Library: Len()
Post by: bbasujon on August 15, 2012, 05:16:26 PM
Function: Len()

Purpose: The Len() function takes a string as input and returns an integer corresponding to the length of the string.

Usage: Len(string)

Returns: Length of the input string

Example:

Dim MyString() As String = {"Testing, Testing, 123"}
Dim Result As Integer = Len(MyString)

In this example, Result would be 19, the length of MyString.