forcing text as UPPERCASE

[coach4u]

Trying to help a client w/ Access, have basic understanding of concepts and some functions. How do I force a field to input text in UPPERCASE?

Also how would I set the field for this type of entry?
04-e-0560

Thanks for your help.
PV

 

[jaydeebetoo]

first part - not sure

second part - create a custom input mask for that field in the table design. something like 00-?-0000 should work.

 

[jaydeebetoo]

first part- look at the input mask help section.

< converts everything to lowercase
> converts everything to uppercase

so you could have an input mask for that field that is just >

 

[Blorf]

Hi. If you have a text box called mybox, try putting this in the after update event on your form for that text box.

me!mybox = ucase (me!mybox)

Chaz

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

http://mysite.verizon.net/res0n4sv/

 

[Remou]

Hi
If you use Input Mask, you can enter
>00\-L\-000;0
This says MUST have 2 numbers, dash, uppercase letter, three numbers. ;0 says store the dashes too.

 

[PWise]

in after update of the control me.controlname = ucase(me.controlname)
this will change the control to upper case