Convert Uppercase to Titlecase in Query

[David Bailey]

I am trying to write a query to convert text in a field from upper case to title case. I can easily convert text into lowercase using the lcase function or if I wanted upper case using the ucase function, but there does not appear to be a function to convert to title case. i.e first letter of a world in capitals and the rest lower case.

Assuming was converting to lower case my formula looks like this:

Title Case Salutation: LCase(Format([Upper Case Salutation]))

Where "Title case salutation" is the name of the field to be and "upper case salutation" is the name of the current field

Is there a Tcase formula or similar to do the same but convert to title case?

 

[Pat Hartman]

This is also referred to as proper. You can use StrConv() for a variety of case conversions.

 

[David Bailey]

Thanks for your response

Any chance of an example of the use of StrConv to convert a field from upper case to title case?

Much appreciated

 

[Pat Hartman]

I guess your copy of help doesn't work.

StrConv(YourField, 3)