David McAfee
davidmcafee at gmail.com
Wed Feb 26 15:08:08 CST 2014
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: Input Output DAVID MCAFEE David McAfee david mcafee David McAfee eee movers EEE Movers joe bob smith Joe Bob Smith mary jo brady Mary Jo Brady a.b.c. industries A.B.C. Industries b&b mfg B&B Mfg sharon o'conner Sharon O'Conner don't Don't tom's diner Tom's Diner Adamczyk Adamczyk tomcheck Tomcheck oscar de la hoya Oscar de La Hoya a b c Manufacturing A B C Manufacturing florina dimartini Florina diMartini On Tue, Feb 25, 2014 at 10:57 PM, Kathryn Bassett <kathryn at bassett.net>wrote: > Thanks, I'll give it a try tomorrow. >