Bill Benson
bensonforums at gmail.com
Mon Mar 3 19:40:15 CST 2014
Yes I noticed ... and that is why I jokingly said it makes a difference, as I am in NY... otherwise might have done the same. :-) Glad you were helped. If word gets out that David makes house calls for database issues, we all might move to CA. Bill -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kathryn Bassett Sent: Monday, March 03, 2014 8:36 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] THANKS!!! RE: Converting case Yes, you'll notice Pasadena CA in my sig. He lives about 2 miles from me. > -----Original Message----- > From: accessd-bounces at databaseadvisors.com [mailto:accessd- > bounces at databaseadvisors.com] On Behalf Of Bill Benson > Sent: 03 Mar 2014 5:32 PM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] THANKS!!! RE: Converting case > > Uh, is David in California? It makes all the difference. > > -- New York. > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kathryn > Bassett > Sent: Monday, March 03, 2014 12:18 PM > To: 'Access Developers discussion and problem solving' > Subject: [AccessD] THANKS!!! RE: Converting case > > I wanted to publicly thank David McAfee for the personal touch. Last night he > came over to my house and did a hands-on tutorial on how to use his code. > > -- > Kathryn Rhinehart Bassett (Pasadena CA) > "Genealogy is my bag" "GH is my soap" > kathryn at bassett.net > http://bassett.net > > > > > > -----Original Message----- > > From: accessd-bounces at databaseadvisors.com [mailto:accessd- > > bounces at databaseadvisors.com] On Behalf Of David McAfee > > Sent: 26 Feb 2014 1:08 PM > > To: Access Developers discussion and problem solving > > Subject: Re: [AccessD] Converting case > > > > In addition to UCase, and VB ProperCase, I created one years ago. > > I never liked the way Proper Case worked. > > > > My code is fugly, but it works. I updated the SQL version a few years > > ago (but never uploaded it on Roger's site) > > > > Anyway, if you'd like to try it you can download it from: > > http://www.rogersaccesslibrary.com/forum/proper-case- > > function_topic166.html > > > > Here's a sample of input and outputs: > > > -- > 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com