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

W

WendyWest

I have a form with a state field that I want to force to upper case if it is
entered incorrectly.
 
S

Sandra Daigle

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

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

WendyWest

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...
 
Top