Convert to Uppercase

justsimple · Post by **justsimple** » Tue Jan 10, 2017 11:10 am

How do convert anything in company field to uppercase ?
make sure it will save as well in table so when i lookup that company from different table, it will show uppercase.

mobhar · Post by **mobhar** » Tue Jan 10, 2017 11:20 am

This following posts should help:

justsimple · Post by **justsimple** » Tue Jan 10, 2017 12:21 pm

yes it works but it won't save in table as uppercase.
so if I make a report, it will still shows as lowercase.

mobhar · Post by **mobhar** » Tue Jan 10, 2017 1:19 pm

To save the uppercase value into Database while user adding new record, then you may simply use the following code in "Row_Inserting" server event:

$rsnew["YourFieldName"] = strtoupper($rsnew["YourFieldName"]);