more about lower case and upper case

[Larry]

Hi, thank you guys for great helps....
actually what I really wanted was:
"I AM A BIG MAN" => "I Am A Big Man"
Sorry for the confusion...
and I am also reading whole bunch of strings from a database.
Thank you!

[Rick Rothstein]

Look up LCase$ in the VB help files (also of interest may be UCase$).

Rick


"Larry" <l-sun@nwu.edu> wrote in message news:39539cc2$1@news.devx.com...
>
> Hi, thank you guys for great helps....
> actually what I really wanted was:
> "I AM A BIG MAN" => "I Am A Big Man"
> Sorry for the confusion...
> and I am also reading whole bunch of strings from a database.
> Thank you!

[Rick Rothstein]

****, I gotta read these questions more carefully . . .

Larry, you want the StrConv function and you want to use the vbProperCase
argument; like so

MsgBox StrConv("I AM A BIG MAN", vbProperCase)

Rick


"Rick Rothstein" <rick_newsgroup@email.com> wrote in message
news:39539dc4$1@news.devx.com...
> Look up LCase$ in the VB help files (also of interest may be UCase$).
>
> Rick
>
>
> "Larry" <l-sun@nwu.edu> wrote in message news:39539cc2$1@news.devx.com...
> >
> > Hi, thank you guys for great helps....
> > actually what I really wanted was:
> > "I AM A BIG MAN" => "I Am A Big Man"
> > Sorry for the confusion...
> > and I am also reading whole bunch of strings from a database.
> > Thank you!
>
>