Format Property: Text field to Titlecase

I need to set the format property of a text field so that
it formats using Titlecase...I want the first letter of
every word to be capitalized.

I've already tried the syntax below and it doesn't work.



Thanks for your help.

Off the top of my head, the function I believe you need to use is: StrConv()

Check the help file for the correct syntax.

If you are using it in a text box control, you could do the following:

ControlSource: =StrConv([FormalSalutation])

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
"Vickie" wrote in message
...
I need to set the format property of a text field so that
it formats using Titlecase...I want the first letter of
every word to be capitalized.

I've already tried the syntax below and it doesn't work.



Thanks for your help.