uppercase Inputmask

[lupien1]

When defining a field with an inpumask to uppercase the data entry, do we have to always repeat the letter length time following the > to force all letter to be capitalize. There must be a simple mask to do the same job.

ex. to uppercase every letter from a 10 characters text field i do:

>CCCCCCCCCC

is there something like the following to do the same job:

>*

Thank You!

 

[Remou]

Hi
Must it be the Input Mask? If you use > as a Format, all characters will be forced to uppercase.

 

[lupien1]

Thank you Remou,

I tried your suggestion and it work, but we need to quit the field to see the effect. That's OK but i keep asking the question about the Inputmask to see the effect as we type.

 

[lupien1]

Hi Remou,

There is a problem about the > as a format. The data is store in lowercase, but we see it in uppercase in the access field. If i gain the focus in the access field, the data is converted in lowercase as it is store. If i query this field with another product (SQL*Plus) the result is in lowercase.

So the solution must be from the Inputmask.

 

[Lilliabeth]

http://support.microsoft.com/?kbid=209520

 

[lupien1]

Thank you Lilliabeth,

But we are not using access Forms and a value can be insert from other product like msquery, SQL*Forms or SQL*Plus. So, the mask must be use for my case.