UCase
Using the UCASE Function
In this tutorial you will learn how to use the UCASE Function.
The UCASE function returns a String that has been converted to uppercase.
=UCASE( string )
string the value you wish to convert to uppercase
In this example we will work with a sentance: "Change the Case".
The result is CHANGE THE CASE.
FORM
In a Form you could set the Default Value of a Textbox to
=UCASE("Change the Case")
VBA
In a Form add a TEXTBOX control and rename it "txtUCase", then you could add the following in the Load Event.
Private Sub Form_Load()
txtLCase = UCASE("Change the Case")
End Sub
Courses
Access Expert 13
Access 222
Seminars
SQL 2
Search
You can find more about this by searching the website.
By: Alex Hedley
Click here to sign up for more FREE tips
|