Re: can I convert to first letter upper case when all are uppercase
- From: "Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx>
- Date: Tue, 2 Jan 2007 18:37:11 -0500
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
.
- Prev by Date: Re: Import from Word
- Next by Date: Using Row headings instead of Column Headings with DoCmd.TransferSpread***
- Previous by thread: Re: Import from Word
- Next by thread: Re: can I convert to first letter upper case when all are uppercas
- Index(es):