How to convert fields in lower case/upper case within Info path forms
Info path forms does not have any function to convert fields to lowercase or uppercase but there is an easy way to do it by using the translate function. Basically, the translate function returns the first argument string with occurrences of characters in the second argument string replaced by the character at the corresponding in the third argument. Using the translate function we can convert fields from upper case to lower case, first word in upper case... or even use it to remove all the dashes and colons. The Translate function is better than the Replace function as can change several words at the same time. If we want every single character to get converted, we will have to specify every letter in the alphabet in upper case and then lower case to make sure every character will get converted. These are some examples: Converting from UPPER case to Lower case: translate( FieldToConvert , "ABCDEFGHIJKLMNOPQRSTUVWXYZ", "abcdefghijklmnopqrstuvwxyz") C