changing All Caps to Title Case - really changing it

[sawhillr]

is there a way to truly convert the contents of a field to title case instead of changing its style (which doesn't really change the contents)? I need to apply this to a headline field that is always in All caps from the source.

The problem with changing anything to Title case using styles is that there may be a word that needs to be in all caps (EPA, USA, FBI) so someone has to manually fix them. But if you apply a style, there is no way to change just one word. Also, FM's Title Case function is a bit dumb, it sees a quotation mark as the first letter of a word and will then change what it thinks is the second letter, the first letter of the word, to lowercase.

Thanks

Roger

[David Jondreau]

Try the Replace Field Contents[] script step using the Proper() function with the parameter Self to fix existing records.

Put Proper(Self) in an auto-enter calc for the field for new records.

[sawhillr]

Thanks DJ, haven't tried that function before.