Changing case in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top