formatting initial caps

[Guest]

A name in my db is all caps like this: ST MARY COMMUNITY CHURCH. The name is
all in one field. I want the output to be initial caps only, like this: St
Mary Community Church. Is there a way in either an Input Mask or by using
the Format function, or other, to create initial caps?

 

[Duane Hookom]

You can generally use
StrConv([YourField],3)
This expression might cause issues with some names where you want other than
propercasing.