Want to Make Field Uppercase at Form Level.

Stivan_dsouza21 · 2012-07-03

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 · 2012-07-03

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 · 2012-07-03

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) ;

Want to Make Field Uppercase at Form Level.

Comments

Categories