G Guest Feb 28, 2006 #1 How to capitalize the first letter of every word (for names)? Thank you in advance
L Lynn Trapp Feb 28, 2006 #2 In a query this should work for you: StrConv([YourField],3) -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Access Junkie List: http://home.bendbroadband.com/conradsystems/accessjunkie.html
In a query this should work for you: StrConv([YourField],3) -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Access Junkie List: http://home.bendbroadband.com/conradsystems/accessjunkie.html
