Want to Make Field Uppercase at Form Level.

Stivan_dsouza21

Want to Make Field Uppercase at Form Level.

1) I have defined the Source Expr Property of that field as UPPERCASE("Description 2").

But when i Enter the an Description and i press Enter then it becomes Blank.


Can somebody suggest Why?????....

mohana_cse06

If you can make the field Datatype to code.
or
Write below code in table Description 2 onvalidate trigger

"Description 2" := UPPERCASE("Description 2");

MBerger

3rd option, useable if it is only visual and the uppercase variant doesn't have to be saved to the table, is to change the OnFormat trigger on the form :

text := uppercase(text) ;