format a text field

A

alison.justice

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

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
 
Top