[AccessD] (OT) Propercase update for last names

in fact 'von' is always lower case in Germany (and it is originally German)
Lembit Soobik

----- Original Message ----- 
From: "John B." <john at winhaven.net>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Wednesday, October 15, 2003 4:23 AM
Subject: RE: [AccessD] (OT) Propercase update for last names


> Oleg,
> Von is not always capitilized. I don't know of any rule but quite often it
> is all lowercase. For my ProperCase function I use a lookup table for
> exceptions and have a edit form for the totally unusual situations.
>
> HTH
> John B.
> WinHaven LLC
> :o)
>
> > -----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 11:41 AM
> > To: accessd at databaseadvisors.com
> > 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 ?
> >
> >
> > -----------------------------------------
> > Get Breaking News from CNN, ABC, NBC, CBS Now.
> > http://www.xuppa.com/news/?link=webmail
> >
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> >
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>