totn Access Functions

MS Access: UCase Function

This MSAccess tutorial explains how to use the Access UCase function with syntax and examples.

Description

The Microsoft Access UCase function converts a string to all upper-case.

Syntax

The syntax for the UCase function in MS Access is:

UCase ( text )

Parameters or Arguments

text
The string that you wish to convert to upper-case.

Applies To

The UCase function can be used in the following versions of Microsoft Access:

  • Access 2019, Access 2016, Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000

Example

Let's look at how to use the UCase function in MS Access:

UCase ("Tech on the Net")
Result: "TECH ON THE NET"

UCase ("Alphabet")
Result: "ALPHABET"

Example in VBA Code

The UCase function can be used in VBA code in Microsoft Access.

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".

Example in SQL/Queries

You can also use the UCase function in a query in Microsoft Access.

For example:

Microsoft Access

In this query, we have used the UCase function as follows:

Expr1: UCase([CategoryName])

This query will convert the CategoryName field to uppercase and display the results in a column called Expr1. You can replace Expr1 with a column name that is more meaningful.

For example:

UppercaseName: UCase([CategoryName])

The results would now be displayed in a column called UppercaseName.

Share on: