formatting initial caps

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
You can generally use
StrConv([YourField],3)
This expression might cause issues with some names where you want other than
propercasing.
 
Back
Top