I download from a data source that puts all text in caps. I would like to use format strings in the table design to force the data the way I want it. Two questions - I cannot find documentation on how to change uppercase to text to first letter upper case and the rest lower case. Also, I need to take a street address that is in all CAPS and do essentially the same thing - i.e. 123 MAIN STREET to 123 Main Street. THanks for any insight
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Custom Text Format Strings Upper to Sentence case
- Thread starter Principal
- Start date
- Status
Similar threads
- Locked
- Question
