Upper to Lower Case

[mdr2271]

Is there a function or routine in Access 2000 that I can use to convert strings of all upper case to the first character being upper case and all the rest being lower case? For example, JOHN DOE would become John Doe.

Thank you.

 

[RoyVidar]

There's a function called StrConv that's supposed to do that. In VBA, you'll use the constants

[tt]msgbox strconv("this is my string", vbpropercase)[/tt]

In queries, you'd need to use the literal

[tt]strconv(myfield, 3)[/tt]

Roy-Vidar