Sting function

[rjoshi2]

Is there a function that will capitalize the first letter of the word and then make the rest of the word lower case?

EXAMPLES
ADMIN becomes Admin
admin becomes Admin

Any help would be appreciated.

Thank You,
rjoshi2

 

[jebry]

Hi rjoshi2!

You can use the StrConv function:

StrConv(YourField, vbProperCase)

hth
Jeff Bridgham
bridgham@purdue.edu

 

[rjoshi2]

How can I use strConv with currentUser.

 

[danvlas]

It's self explanatory, but...

StrConv(CurrentUser,vbProperCase)

Good luck

Daniel Vlas
Systems Consultant

 

[jebry]

Hi!

If I'm not mistaken the CurrentUser function returns a string so you should be able to put it in as the first parameter of the StrConv function. If that doesn't work then you can try it like this:

Dim strUser As String

strUser = CurrentUser()
strUser = StrConv(strUser, vbProperCase)

Then use strUser anyway you like. If you need this in a query then write it into a public function and return strUser. You haven't said how or where you want to use this information so a more specific answer isn't possible.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[rjoshi2]

When I use the strconv with currentuser all I get back is ???

 

[jebry]

Hi!

Where are you using this? Is it the control source in a form? Is it a calculated field in a query? We need more info!

Jeff Bridgham
bridgham@purdue.edu