Changing case in Access

[Theresa]

I recieved an access data table from someone else. All the 6,000 records are
in uppercase which creates a mess when outputting reports and letters. How
do I change the case in specific fields within Access? I would like to change
Names addresses and Cities to title case. I am running Access 2002

 

[Douglas J. Steele]

Check out the StrConv function.

An update query along the lines of

UPDATE MyTable
SET MyName = StrConv([MyName], 3),
MyAddress = StrConv([MyAddress], 3),
MyCity = StrConv([MyCity], 3)

shoud do it.