Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

String question 2

Status
Not open for further replies.

sborny

Technical User
Jun 29, 2001
157
GB
Hi All,

Is there a way to change any captial letters in a string to lower case.

Thanks.

S.

Everything has an answer, it's just knowing the right question to ask. !!!!
 
and just for reference, UCase("TeSt") for uppercase conversion :)
 
There's a third one for 'proper' case conversion (uppercases first letter of word, lowercases remainder), but it's only available if you use StrConv:

StrConv("yourString", vbProperCase)
 
Thankyou strongm, that will do nicely. Have a star. Just when I needed it. Regards
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top