In Access, the LCase function returns a Variant in which all letters of an argument have been converted to lowercase.

The syntax for the LCase function is:

Lcase ( string )

The argument string can be any string expression. However, if string contains Null, Null is returned. Only uppercase letters are converted to lowercase; all lowercase letters and nonletter characters remain unchanged.

Example

LCase( "Hello World" )      returns "hello world" LCase( "TEST123" )          returns "test123"

VBA Code

Dim UpperCase, LowerCase Uppercase = "Web CheatSheet" Lowercase = Lcase(UpperCase)

This example uses the LCase function to return a lowercase version of a string. Now the variable called LowerCase would contain the value "web cheatsheet".

SQL query

You can also use the LCase function in a query.

SELECT LCase([ItemDesired]) AS Expr1 FROM Orders