Automatically make the first letter capital and the rest of the word lowercase in InfoPath

Sceniro: We want to make the first letter capital of a word and rest of them are in lowercase. For example, “mary” –> “Mary”.

This is the formula. It has been tested.

concat(translate(substring(field1, 1, 1), “abcdefghijklmnopqrstuvwxyz”, “ABCDEFGHIJKLMNOPQRSTUVWXYZ”), translate(substring(field1, 2, string-length(field1)), “ABCDEFGHIJKLMNOPQRSTUVWXYZ”, “abcdefghijklmnopqrstuvwxyz”))

Simply change “field1” to the column name which you want to apply.