Text field properties format

[Bobby Baxter]

Access 2002, WinXP Pro


1. For a text field what do I enter in properties>format so that the first
letter of each word is capitalized such as a person's name: "John Q. Doe"


2. For different text field what do I enter in properties>format so that the
first letter of each word is capitalized as well as each letter that follows
either a "-" (dash) or "." (period) such as: "Salter-E.H."

Thank you,

Bobby

--
Bobby Baxter
TheGardenSite.com

~~~~~~~~~~~~~~~~~~~~~~~~~~~
TheGardenSite.com: http://thegardensite.com
Daylily.Net: http://daylily.net
Happy Moose: http://happymoosegardens.com
Garden Discussion Forum: http://happymoose.com

Specializing in designing web sites for plant lovers!

 

[Steve Schapel]

Bobby,

The result you seek is not possible by using the Format property of a
field or control.

You would be advised to run an Update Query on your data, to update
[YourField] to...
StrConv([YourField],3)
.... in order to have your data in Proper Case.

In order to achieve the second result, I think you would need to write a
User-Defined Function which cycles through your data cahacter by
character, and capitalises according to your requirements.

 

[Bobby Baxter]

Thanks Steve, I will give this a try.

Bobby