Access: LCase Function

In Access, the LCase function converts a string to lower-case.

The syntax for the LCase function is:

LCase ( text )

Text is the string that you wish to convert to lower-case.

For example:

LCase ("Tech on the Net") would return "tech on the net"

LCase ("124ABC") would return "124abc"

VBA Code

The LCase function can be used in VBA code. For example:

Dim LResult As String

LResult = LCase ("This is a TEST")

In this example, the variable called LResult would now contain the value "this is a test".

You can also use the LCase function in a query.