Change a fields value to lowercase in InfoPath 2010

Ahhh! My first form is almost finished… Just thought i’d blog this function (even though it’s probably hanging arround a million other places on the net).

I needed to ensure a few fields were always lowercase so I applied the translate function as a rule to the required fields:

translate(.,"ABCDEFGHIJKLMNOPQRSTUVWYXZ", "abcdefghijklmnopqrstuvwyxz")

“.” (above) referes to the current field.

The rule it self looks like this:

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.