convert text to LCase 2

[optjco]

I am using SYSGetUserName to populate a label on a form with the appropiate username however this could be in one of three different cases i.e.

JBloggs
jbloggs
JBLOGGS

I would like to be able to convert the name to lowercase at all times

This is how I populate the label now

lblUserName.Caption = SYSGetUserName

could someone suggest how I would change it so that it does change to lowercase please

Regards

Olly

 

[HarleyQuinn]

How about

lblUserName.Caption = StrConv(SYSGetUserName,vbLowerCase)

Hope this helps

Harleyquinn
---------------------------------
Help us to help you,
read FAQ222-2244 before posting.

 

[PHV]

Another way:
lblUserName.Caption = LCase(SYSGetUserName)

You may also consider this:
lblUserName.Caption = LCase(Environ("UserName"))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[optjco]

HarleyQuinn/PHV
Thank you both for your suggestions, I will try them both tomorrow

Regards

Olly