How do I change an Access field to upper case after lost focus?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with a state field that I want to force to upper case if it is
entered incorrectly.
 
Use the strConv function - put this in the AfterUpdate event of the control:

Me.State = StrConv(Me.State, vbUpperCase)
 
Thank you!

Sandra Daigle said:
Use the strConv function - put this in the AfterUpdate event of the control:

Me.State = StrConv(Me.State, vbUpperCase)

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

I have a form with a state field that I want to force to upper case
if it is entered incorrectly.
Click to expand...
Click to expand...
 
Back
Top