Converting CASE

A

android

I have kept my book collection on Access and it is huge. For some reason
I entered everything in upper case. Is there any way of converting the
case to sentence case (i.e. just Caps where needed and the rest lower
case.:confused:
 
D

Douglas J. Steele

StrConv(strTextToConvert, vbProperCase) will convert the first letter of
every word in string to uppercase. If you only want the first letter to be
capitalized, try

UCase(Left(strTextToConvert, 1)) & LCase(Mid(strTextToConvert, 2))
 

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

Word doc keeps changing to ALL CAPS 0
Converting URLs in comments to Markdown-formatted links 2
List all tables, including document structure 0
I have lost 6 months work, how can i get my file back 1
Autonumber field in Excel that behaves the same as Access 0
How do I convert addresses to all caps in Office 2007? 3
upper case - lower case issues - dropdown box is case sensitive??? 0
Convert list to UPPER, lower & Proper cases. 21

Top