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