UCase not working 1

[wx5chr]

I have a field (ST) in the main form. Pressing TAB from this field puts the focus into a subform.

I want to ensure the state abbreviation is uppercase, so I tried all of the following in the OnLostFocus Event:

UCase (Me.ST)
UCase Me.ST
UCase ("[Me.ST]&quot

Any ideas why none of these work?

 

[LarryDeLaruelle]

The syntax should be:

me.st = ucase(me.st)

But, why not use an input mask to force uppercase - >LL

This will not only force upper case, but will insure that only alpha characters are entered.

Larry De Laruelle
ldelaruelle@familychildrenscenter.org

 

[SteveR77]

The UCase is fine but you need to do the assignment back to the control like this -

Me.ST = UCase(Me.ST)


Hope this helps you,

Steve

 

[gasx]

try this on press key event:

KeyAscii = Asc(UCase(Chr(KeyAscii)))

have a good luck!

 

[wx5chr]

Thanks very much for the quick replies. I decided to use > in the format.

 

[JustLJ]

gasx;
I love that OnPressKey trick!
Thanks for sharing!
LJ