Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Uppercase Text Format or Input Mask

Status
Not open for further replies.

bob000

Programmer
Aug 23, 2001
20
US
I have a form with a text box I would like to be entered in all uppercase text values. How would I do this on the Format, Input Mask or some other way? Can this be done in the the Table definition as well as the Form.
 
Create an OnExit event and put the following code in it:

txtName = UCase([txtName])

Use the name of the field you wish to have made uppercase. Then when the user is tabing from one field to the next it will convert everything in the field they are just leaving to be upper case.

Hope this helps
 
Put a > in the format property of your text box to display in uppercase, or in the table's design view to store the record in uppercase.....
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top