Re: can I convert to first letter upper case when all are uppercase

Tech-Archive recommends: Fix windows errors by optimizing your registry



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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"mikeinohio" <mikeinohio@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:15C6CD7D-7773-4FB6-B630-77E4C7BAE6DA@xxxxxxxxxxxxxxxx
i have a table full of data that is uppper case data in a few coloums bu
i
wantot t be first leter uppercase and the rest of the road lower case
through
out the column


.


Quantcast