|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 18th, 2004, 08:46 PM
|
|||
|
|||
Uppercase to Title Case
Does anyone know how to change uppercase data that was
imported into Access to title case? I know how to convert uppercase to lowercase and lowercase to uppercase. Any input would help! 
|
|
#2
November 18th, 2004, 09:12 PM
|
|||
|
|||
|
see reply in other newsgroup where you posted this question.
-- Ken Snell MS ACCESS MVP "Jeannette" wrote in message ... Does anyone know how to change uppercase data that was imported into Access to title case? I know how to convert uppercase to lowercase and lowercase to uppercase. Any input would help!
|
|
#3
November 19th, 2004, 12:11 PM
|
|||
|
|||
|
I use this code:
myWord = StrConv(myWord, vbProperCase) However, MACDONALD becomes Macdonald so you may consider a table of exceptions that contains prefixes, eg Mac, and other exceptions such as names eg MacDonald. My version changed macerator into MacErator so have fun. "Jeannette" wrote: Does anyone know how to change uppercase data that was imported into Access to title case? I know how to convert uppercase to lowercase and lowercase to uppercase. Any input would help!
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Uppercase to Title Case | Jeannette | General Discussion | 1 | November 18th, 2004 09:07 PM |
| chart help please | jvoortman | General Discussion | 7 | September 17th, 2004 01:30 AM |
| check writing code | funkmaster22 | Using Forms | 2 | August 11th, 2004 09:35 PM |
| Is it possible to filter based on ceel format | ludahen | Worksheet Functions | 4 | June 9th, 2004 09:19 PM |
| Readding Numerical value to ext | Hoang Han | Worksheet Functions | 2 | December 4th, 2003 05:37 PM |
Linear Mode
