Access: UCase Function

In Access, the UCase function converts a string to all upper-case.

The syntax for the UCase function is:

UCase ( text )

text is the string that you wish to convert to upper-case.

For example:

UCase ("Tech on the Net") would return "TECH ON THE NET"

UCase ("Alphabet") would return "ALPHABET"

VBA Code

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

Dim LResult As String

LResult = UCase ("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 UCase function in a query.