A alison.justice Jun 1, 2009 #1 How can I format a text field that the data is in all caps to where every word starts with a capital letter?
How can I format a text field that the data is in all caps to where every word starts with a capital letter?
S Steve Schapel Jun 1, 2009 #2 Alison, Making sure you have a backup of your database, use an Update Query to update TheField to... StrConv([TheField],3) -- Steve Schapel, Microsoft Access MVP alison.justice said: How can I format a text field that the data is in all caps to where every word starts with a capital letter? Click to expand... __________ Information from ESET Smart Security, version of virus signature database 4120 (20090601) __________ The message was checked by ESET Smart Security. http://www.eset.com
Alison, Making sure you have a backup of your database, use an Update Query to update TheField to... StrConv([TheField],3) -- Steve Schapel, Microsoft Access MVP alison.justice said: How can I format a text field that the data is in all caps to where every word starts with a capital letter? Click to expand... __________ Information from ESET Smart Security, version of virus signature database 4120 (20090601) __________ The message was checked by ESET Smart Security. http://www.eset.com
