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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting inital caps 2
Formatting Labels 2
Initial Caps Problem 6
paragraph initial words in small caps 1
changing "case" of letters 4
Why isn't autocorrect working on two initial capital letters? 2
Excel VBA in Excel 07 Line Style Cap Type 1
IPad remote 10

Back
Top