View Full Version : Auto convert to Uppercase letter


AstonCheah
10-28-2008, 07:18 PM
how to run a code which will automatically convert to uppercase letter when key in lowercase letter?

anyone can help?

thanks.

boblarson
10-28-2008, 07:34 PM
If you want ALL letters entered to be stored this way, you can put this in the BeforeUpdate event of the control:

Me.YourControlName = UCase(Me.YourControlName)

AstonCheah
10-28-2008, 09:12 PM
thanks boblarson, works well.