Daffodil Computers Ltd.

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

Title: Microsoft Access Function Library: Lcase()
Post by: bbasujon on August 15, 2012, 05:14:31 PM
Function: LCase()

Purpose: The LCase() function converts all of the uppercase letters in a string to their lowercase equivalents. Characters that are already uppercase or are non-alphabetic are left intact.

Usage: Lcase(string)

Returns: String with all uppercase letters converted to lowercase.

Example:

Dim MyString() As String = {"Testing, Testing, 123"}
Dim ResultString As String = LCase(MyString)

In this example, ResultString would contain "testing, testing, 123"