If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Format Property: Text field to Titlecase
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. |
Thread Tools | |
Display Modes | |
|
|