text manipulation- proper case

[Guest]

Hi-
I am trying to create a field in a query to change a name to proper case.
I know if I put
Expr1: UCase([FirstName])
I can return the upper case of field one. How do I get it to return the
proper case?
Thanks

 

[Sergey Poberezovskiy]

Use

StrConv(myString, vbProperCase)

function

HTH

 

[Van T. Dinh]

ProperFirstName: StrConv([FirstName], 3)