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

How do I convert addresses to all caps in Office 2007? 3
about column value in table 2
converting uppercase to proper case 4
Validate data but then change the entry to upper case 4
upper case 1
Formatting cells to only upper case 5
Change from all UPPER case letters 5
SQL to take string from a form WITHOUT converting it 2

Top