Text field - convert Uppercase text to Mixed case text

I have data in a text field with a mixture of records being either all upper case text or being of mixed case text  (e.g.,  MARY SMITH; George Simpson).    I need a simple way to convert  "upper case" records to mixed case.  

Using a query, I can change everything to uppercase or lowercase -- but I'm not sure how to get to "mixed".

The database I'm looking at is actually an SQL database and I'm linking to the the tables using Access.

Any help would be appreciated.

Thanks,
Methos
MethosAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
nico5038Connect With a Mentor Commented:
Just checkout:
http://www.experts-exchange.com/questions/Q.20081543.html

Not only the selected answer but also the vbPropercase of Paurths might be interesting...

Nic;o)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.