Formatting inital 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?

 

[Arvin Meyer [MVP]]

You can use the AfterUpdate event to do something like:

Sub MyField_AfterUpdate()
MyField = StrConv(MyField, vbProperCase)
End Sub

or fix the existing data in a query:

Update MyTable.MyField Set StrConv(MyField, 3)
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Guest]

Thx. Looked all over for something like this. Works great.