Solved

Text field - convert Uppercase text to Mixed case text

Posted on 2002-03-25
1
750 Views
Last Modified: 2012-06-27
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
0
Comment
Question by:Methos
1 Comment
 
LVL 54

Accepted Solution

by:
nico5038 earned 200 total points
ID: 6895119
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

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now