Need help with vba and access

[Chris]

Im having a problem with doing something for hw with access. It says it
wants me to create a function in a form that converts all X field names to
proper case - capitalize the first letter of eac hword, and convert all
other letters to lower-case.
Can anyone help me on writing this one function

 

[Guest]

Function Proper_Case(strWord) as string
Dim Result as string

Result = ucase(left(strWord,1)) & lcase(mid(strWord,2))
Proper_Case=Result
End Function


JL5000
<a href="www.joshdev.com"></a>

 

[Van T. Dinh]

Check Access VB Help on the StrConv() function.

HTH
Van T. Dinh
MVP (Access)