![]() |
| 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. |
|
|||||||
| Tags: 2003, custom, folders, outlook, public, templates |
|
|
Thread Tools | Display Modes |
|
#21
|
|||
|
|||
|
You must use the field names, not control names. Drag the Subject property to a custom page on your form. Right-click the resulting text box, and choose Properties. On the Value tab, at the bottom, click the Edit button to open the formula builder. I strongly suggest you use the Field button to choose fields rather than risk typos by typing them in. You'll also want to set the option on the Value tab to "Calculate the formula automatically.
-- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Scott07" wrote in message ... So you mean something like the following? Would that link the three textboxes together? [textbox1]& " " &[textbox2]& " " &[textbox3] If that's correct and they're linked, how do I tie them to the "Subject" property? "Sue Mosher [MVP-Outlook]" wrote: If you use the formula editor to pick the fields, you'll see the field syntax that formulas take. After that, it's simple string operators. [YourField] & " " & [YourOtherField] etc. "Scott07" wrote in message ... Any suggestions on where to find examples for the formula to concatenate my other textboxes' properties to the Subject property's textbox? "Sue Mosher [MVP-Outlook]" wrote: You need to bind each text box to a separate property, creating new ones as needed. Once you've done that, you can set a formula on the Subject property's text box to concatenate those new properties' values to build the Subject. "Scott07" wrote in message ... Thank you for your response, patience, and guidance. I've tried using textboxes bound to the "Subject" property, but the problem I keep experiencing is the following. Since all of my textboxes are bound to the "Subject" property, if I type "Test" into one of the textboxes , they will all become filled with "Test." Is there a way to maintain the "Subject" field's properties, but differentiate them so that they do not copy each other's contents? Thanks again. At this point, what might be the simplest solution is to use textboxes bound to custom Outlook properties and then set the value of the Subject property using a formula. To do that, you'd need to add Subject to a custom form page, so you can get to its control Properties, but that can be on a hidden page. |
| Ads |
|
#22
|
|||
|
|||
|
Got it working! Thanks so much!
"Sue Mosher [MVP-Outlook]" wrote: You must use the field names, not control names. Drag the Subject property to a custom page on your form. Right-click the resulting text box, and choose Properties. On the Value tab, at the bottom, click the Edit button to open the formula builder. I strongly suggest you use the Field button to choose fields rather than risk typos by typing them in. You'll also want to set the option on the Value tab to "Calculate the formula automatically. -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Scott07" wrote in message ... So you mean something like the following? Would that link the three textboxes together? [textbox1]& " " &[textbox2]& " " &[textbox3] If that's correct and they're linked, how do I tie them to the "Subject" property? "Sue Mosher [MVP-Outlook]" wrote: If you use the formula editor to pick the fields, you'll see the field syntax that formulas take. After that, it's simple string operators. [YourField] & " " & [YourOtherField] etc. "Scott07" wrote in message ... Any suggestions on where to find examples for the formula to concatenate my other textboxes' properties to the Subject property's textbox? "Sue Mosher [MVP-Outlook]" wrote: You need to bind each text box to a separate property, creating new ones as needed. Once you've done that, you can set a formula on the Subject property's text box to concatenate those new properties' values to build the Subject. "Scott07" wrote in message ... Thank you for your response, patience, and guidance. I've tried using textboxes bound to the "Subject" property, but the problem I keep experiencing is the following. Since all of my textboxes are bound to the "Subject" property, if I type "Test" into one of the textboxes , they will all become filled with "Test." Is there a way to maintain the "Subject" field's properties, but differentiate them so that they do not copy each other's contents? Thanks again. At this point, what might be the simplest solution is to use textboxes bound to custom Outlook properties and then set the value of the Subject property using a formula. To do that, you'd need to add Subject to a custom form page, so you can get to its control Properties, but that can be on a hidden page. |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Outlook 2003 - Custom Templates for Public Folders | Foodbank | Outlook - General Queries | 1 | May 17th 07 03:19 PM |
| custom forms without public folders and client installation | berndsoft@googlemail.com | Outlook - Using Forms | 1 | April 17th 07 05:34 AM |
| exchange server 2003/ outlook 2002 and 2003 and public folders | t north | Outlook - Using Contacts | 0 | March 6th 07 08:18 PM |
| Keyboard shortcut for custom view in public folders | JD2 | Outlook and VBA | 0 | September 7th 06 09:38 AM |
| Attaching Custom Forms to Existing Contacts in Public Folders | jyu1018@gmail.com | Outlook - Using Forms | 2 | August 23rd 06 02:41 AM |