formatting initial caps

B

Brossyg

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?
 
D

Duane Hookom

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