David McAfee
DMcAfee at haascnc.com
Tue Oct 14 15:20:22 CDT 2003
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 ?