Access: LCase Function

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.


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


Leave a Reply

Your email address will not be published.