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:
UCase(String)
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.
Example
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".