Want to Make Field Uppercase at Form Level.

Stivan_dsouza21 · **Posted:** Tue Jul 03, 2012 6:11 am

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 · **Posted:** Tue Jul 03, 2012 6:18 am

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 · **Posted:** Tue Jul 03, 2012 11:05 am

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 :

Code: Select all

text := uppercase(text) ;

mibuso.com

Want to Make Field Uppercase at Form Level.

Who is online