Quick Capitilaztion Question

illy2k

Registered User.
Local time
Today, 18:11
Joined
Apr 21, 2003
Messages
51
I have a field on my form, that needs to always be capitalized. If some one enters "in" I need it to automatically change to "IN", when they tab out of the box, so an after update event. How can I do this with the UCase() Function? Or by any other means?
 
On the AfterUpdate property of the field in question use Event Procedure: [Name of Field]. value = UCase([Name of Field]) HTH JT
 

Users who are viewing this thread

Back
Top Bottom