How Change format to start with Capital Letters

H

Heilbron

I want to change the field in a form to format the text input as follows -
van der merwe format to Van Der Merwe. I don't want all letters in Capital

Working in Access 2003
 
O

Ofer

Try
=strconv([FieldName] ,vbProperCase)

Or, in a query
NewFieldName: strconv([FieldName] ,3)
 
Top