Format Property: Text field to Titlecase

  • Thread starter Thread starter Vickie
  • Start date Start date
V

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.
<
Click to expand...

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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top