Format Property: Text field to Titlecase

[Vickie]

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.

 

[RobFMS]

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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-