access, all caps need to be converted to propercases

[Guest]

I have a database that i merged 6 other databases into. Some years names
were inputted in all caps, other years they were inputted properly. I need to
make all entries have the proper case, ex. Academy of Performing Arts. Can
someone please give me a code that would do this

 

[Rick B]

If you do a search, you will find plenty of posts that explain how to do
this. It can't be done with 100% accuracy though...

Mcdonalds? McDonalds?

Academy Of...?
Academy of...?


No way to handle all these little exceptions easily.

 

[Nikos Yannacopoulos]

Chantelle,

No code required, just an Update query making use of the StrConvert
function like:

UPDATE YourTableName SET YourFieldName= StrConv([YourFiledName],3)

Substitute the actual table and field name and execute.

Wouldn't hurt to back up before you try anything, just in case!

HTH,
Nikos