Gustav Brock
Gustav at cactus.dk
Wed Mar 15 12:59:44 CST 2006
Hi Joe You could use astrWord = Split(strField, " ") to create an array with the words of the field. Then it is easy and quite fast to perform that check. /gustav >>> JRojas at tnco-inc.com 15-03-2006 19:43:20 >>> Good point. I should have included the rest of my logic. I plan on checking to see if each word matches a particular pattern and if it does then I would NOT convert to proper case else I would convert.