Need help with vba and access

C

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
 
J

jl5000

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>
 
V

Van T. Dinh

Check Access VB Help on the StrConv() function.

HTH
Van T. Dinh
MVP (Access)
 
Top