Auto convert to Uppercase letter

[AstonCheah]

how to run a code which will automatically convert to uppercase letter when key in lowercase letter?

anyone can help?

thanks.

 

[boblarson]

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]

thanks boblarson, works well.