How do I covert a database in uppercase letters to Sentence Case?

P

PJCPA

I have an existing table in Access of client names and addresses that was
imported in UPPERCASE letters. I would like to convert this data to Sentence
Case. I am not sure how to do it. Any help would be appreciated.

Thanks

Paul Keating, CPA
 
K

KARL DEWEY

I would open copy and paste the table structure. Open the table in datasheet
view, copy, and then in Word, Paste Special - Formated Text (RTF). Change
case to lower and then to title case. Check to see what did not format
correctly and edit. Copy the table and paste append in the Access table copy.
Run an update query on the orignal table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

upper case letters 4
Merging from an Excel file with graphics 1
Mail Merge Uppercase 2
In Vista, How do I change all UPPERCASE text to Sentence Case? 1
With Vista, how do I change all UPPERCASE text to Sentence Case? 1
Uppercase to Title Case 1
Coverting Upper Case to Lower Case 1
Change Case "Sentence Case" 5

Top