Access: UCase Function

In Access, the UCase function returns a string in which all letters of an argument have been converted to uppercase.

The syntax for the UCase function is:


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


UCase("WebCheatSheet")            returns "WEBCHEATSHEET" 
UCase("Have a nice day")          returns "HAVE A NICE DAY"

VBA Code

Dim UpperCase As String 
UpperCase = UCase("WebCheatSheet")

This example uses the UCase function to return an uppercase version of a string. Now the Uppercase variable would contain the value “WEBCHEATSHEET”.

SQL query

You can also use the UCase function in a query.

SELECT UCase([Item]) AS Expr1
FROM Antiques


Leave a Reply

Your email address will not be published.