-- The Padre
A Al Campagna Jul 8, 2008 #3 Padre, You can use... =strConv([FieldName],3) JOHN SMITH would be John Smith, but... JIM MCKAY would be Jim Mckay. Not perfect, so you may have to do a bit of manual correcting. Or, you can try... http://www.mvps.org/access/strings/str0008.htm that should be more exact. -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life."
Padre, You can use... =strConv([FieldName],3) JOHN SMITH would be John Smith, but... JIM MCKAY would be Jim Mckay. Not perfect, so you may have to do a bit of manual correcting. Or, you can try... http://www.mvps.org/access/strings/str0008.htm that should be more exact. -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life."
