Force UPPERCASE

[jahlmer]

Quick Question:
How do you force uppercase in a field on a form?

For instance, lowercase data is entered, and is then converted to uppercase when the record is saved.

Thanks

 

[Philly44]

In the Controls ControlSource put UCASE(FieldName). That will make Uppercase whenever the control loses focus.

 

[JoeMiller]

Another way is to place this code in the keypress event of the text box:

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

That automatically converts any character to UPPERCASE as the person types.
Joe Miller
joe.miller@flotech.net

 

[jahlmer]

Thanks a lot! You know, sometimes it's hard asking questions when you know you can figure it out, but thanks for your help!