[AccessD] (OT) Propercase update for last names

Oleg, I also made one up several years back. The code is a bit ugly, but it works great. I even allow an optional parameter to prompt the user if they want to correct certain 2 and 3 letter words such as:

 In the example "AAA Insurance", do you want to choose:

		1. aaa
		2. Aaa
		3. AAA


Check it out at:

http://www.rogersaccesslibrary.com/OtherLibraries.asp#McAfee,David

(I'll get around to cleaning up the code "Some" day :)

HTH
David McAfee

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of
Oleg_123 at xuppa.com
Sent: Tuesday, October 14, 2003 10:29 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] (OT) Propercase update for last names


I already got the module from Andy's website, but it only had for Mac*s
I'll go o yours now, thank you

> ...go to www.colbyconsulting.com and dl the ProperCase sample db there
> ...it'll give you what you're looking for ...HTH :)
>
> William Hindman
> "The future will not belong to those who are cynical or
> those who stand on the sidelines. The future will belong to those who
> have passion and are willing to work hard to make our country better."
> ...Paul Wellstone "The Conscience of a Liberal"
>
>
> ----- Original Message -----
> From: <Oleg_123 at xuppa.com>
> To: <accessd at databaseadvisors.com>
> Sent: Tuesday, October 14, 2003 12:40 PM
> Subject: [AccessD] (OT) Propercase update for last names
>
>
>> Hey Group,
>> I run a propercase update for last names excluding following formats
>> McDonald, MacDonald (second or third letter after Mc or Mac
>> respectively) O'Hara, (first letter after apostrophe if first letter
>> in word is "O")
>>
>>  (I am not sure whats the case with d' like D'Umberville)
>> I think Von is always capital, la is always lowercase, and "de"
>> varies. Am I missing anything ?