Re: Uppercase to Mixed Case Edit in Field

Giganews Newsgroups
Subject: Re: Uppercase to Mixed Case Edit in Field
Posted by:  pietlind…@hotmail.com
Date: 8 Aug 2006

Wait, you didn't use the vendor's actual name as a primary key, did
you?  BAD design.  Very bad.  I mean, how many Smiths are in the phone
book?  That's just asking for trouble.  Your first relationship will
work okay, but what happens when you really do have a second "John
Smith".  Make the primary key an autonumber, and then base the
relationships on that.  If you want to convert the text to propercase,
use something like this:

?strconv("david ortiz",vbProperCase)
David Ortiz

Of course, if you have exceptions to the "first letter capitalized"
rule, you're SOL.

Replies

In response to

Uppercase to Mixed Case Edit in Field posted by sara on 8 Aug 2006