InfoPath: Make a field force the contents to be uppercase or lowercase.

Under Fields, Right Click on the field and choose Field Properties.

Under the Default Value section click the “fx” button beside the blank field.

To force the field to be upper case put in this formula:
translate(., “abcdefghijklmnopqrstuvwxyz”, “ABCDEFGHIJKLMNOPQRSTUVWXYZ”)

To force the field to be lower case put in this formula:
translate(., “ABCDEFGHIJKLMNOPQRSTUVWXYZ”, “abcdefghijklmnopqrstuvwxyz”)

This entry was posted in InfoPath, SharePoint and tagged , , . Bookmark the permalink. Follow any comments here with the RSS feed for this post. Post a comment or leave a trackback: Trackback URL.

Leave a Reply

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