|
| 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 | Search this Thread | Display Modes |
|
|
|
#1
June 21st 06, 08:34 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
Changing property of control to all caps
Hello,
First post: I've created an Outlook custom form with some standard controls along with some customized controls. I want to make text in some of the custom controls all caps. How can I do it? In MS Access I could set the property value to "" and it would work fine, but in Outlook forms it doesn't. I've tried many things. One example was writing code in the properties box under properties/Value/Edit, then I tried it in the Script Editor. Example code: (Process Title being the name of my control): [Process Title]=UCase("& [Process Title] &"). No luck. Any ideas? Russ 
|
|
#2
June 21st 06, 08:49 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Changing property of control to all caps
A formula doesn't use =. Simply use:
UCase([Process Title]) -- 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 "Russ" wrote in message oups.com... Hello, First post: I've created an Outlook custom form with some standard controls along with some customized controls. I want to make text in some of the custom controls all caps. How can I do it? In MS Access I could set the property value to "" and it would work fine, but in Outlook forms it doesn't. I've tried many things. One example was writing code in the properties box under properties/Value/Edit, then I tried it in the Script Editor. Example code: (Process Title being the name of my control): [Process Title]=UCase("& [Process Title] &"). No luck. Any ideas? Russ
|
|
#3
June 22nd 06, 03:36 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Changing property of control to all caps
Thanks for your quick reply to my question. Unfortunately this didn't
work. I tried the syntax in two places; the initial value line under properties and in the script editor. The formula is set to calculate when I compose a new form. This is a text box of type text and the "Property to use:" is set to the default "value" value. I haven't had trouble using a textbox of type date/time and using the "NOW" function to autofill the date/time, but for some reason I can't get this UCase to work. Might you have other suggestions? Sue Mosher [MVP-Outlook] wrote: A formula doesn't use =. Simply use: UCase([Process Title]) -- 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 "Russ" wrote in message oups.com... Hello, First post: I've created an Outlook custom form with some standard controls along with some customized controls. I want to make text in some of the custom controls all caps. How can I do it? In MS Access I could set the property value to "" and it would work fine, but in Outlook forms it doesn't. I've tried many things. One example was writing code in the properties box under properties/Value/Edit, then I tried it in the Script Editor. Example code: (Process Title being the name of my control): [Process Title]=UCase("& [Process Title] &"). No luck. Any ideas? Russ
|
|
#4
June 22nd 06, 03:52 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Changing property of control to all caps
Did you remember to change the setting under Initial Value to "Calculate this 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 "Russ" wrote in message oups.com... Thanks for your quick reply to my question. Unfortunately this didn't work. I tried the syntax in two places; the initial value line under properties and in the script editor. The formula is set to calculate when I compose a new form. This is a text box of type text and the "Property to use:" is set to the default "value" value. I haven't had trouble using a textbox of type date/time and using the "NOW" function to autofill the date/time, but for some reason I can't get this UCase to work. Might you have other suggestions? Sue Mosher [MVP-Outlook] wrote: A formula doesn't use =. Simply use: UCase([Process Title]) "Russ" wrote in message oups.com... Hello, First post: I've created an Outlook custom form with some standard controls along with some customized controls. I want to make text in some of the custom controls all caps. How can I do it? In MS Access I could set the property value to "" and it would work fine, but in Outlook forms it doesn't. I've tried many things. One example was writing code in the properties box under properties/Value/Edit, then I tried it in the Script Editor. Example code: (Process Title being the name of my control): [Process Title]=UCase("& [Process Title] &"). No luck. Any ideas? Russ
|
|
#5
June 22nd 06, 05:29 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Changing property of control to all caps
Yes, however when I set it to calculate automatically the text just
diappears. Russ Sue Mosher [MVP-Outlook] wrote: Did you remember to change the setting under Initial Value to "Calculate this 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 "Russ" wrote in message oups.com... Thanks for your quick reply to my question. Unfortunately this didn't work. I tried the syntax in two places; the initial value line under properties and in the script editor. The formula is set to calculate when I compose a new form. This is a text box of type text and the "Property to use:" is set to the default "value" value. I haven't had trouble using a textbox of type date/time and using the "NOW" function to autofill the date/time, but for some reason I can't get this UCase to work. Might you have other suggestions? Sue Mosher [MVP-Outlook] wrote: A formula doesn't use =. Simply use: UCase([Process Title]) "Russ" wrote in message oups.com... Hello, First post: I've created an Outlook custom form with some standard controls along with some customized controls. I want to make text in some of the custom controls all caps. How can I do it? In MS Access I could set the property value to "" and it would work fine, but in Outlook forms it doesn't. I've tried many things. One example was writing code in the properties box under properties/Value/Edit, then I tried it in the Script Editor. Example code: (Process Title being the name of my control): [Process Title]=UCase("& [Process Title] &"). No luck. Any ideas? Russ
|
|
#6
June 22nd 06, 05:33 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Changing property of control to all caps
Formula pointing to the wrong field? Typo in the field name?
-- 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 "Russ" wrote in message oups.com... Yes, however when I set it to calculate automatically the text just diappears. Russ Sue Mosher [MVP-Outlook] wrote: Did you remember to change the setting under Initial Value to "Calculate this formula automatically"? "Russ" wrote in message oups.com... Thanks for your quick reply to my question. Unfortunately this didn't work. I tried the syntax in two places; the initial value line under properties and in the script editor. The formula is set to calculate when I compose a new form. This is a text box of type text and the "Property to use:" is set to the default "value" value. I haven't had trouble using a textbox of type date/time and using the "NOW" function to autofill the date/time, but for some reason I can't get this UCase to work. Might you have other suggestions? Sue Mosher [MVP-Outlook] wrote: A formula doesn't use =. Simply use: UCase([Process Title]) "Russ" wrote in message oups.com... Hello, First post: I've created an Outlook custom form with some standard controls along with some customized controls. I want to make text in some of the custom controls all caps. How can I do it? In MS Access I could set the property value to "" and it would work fine, but in Outlook forms it doesn't. I've tried many things. One example was writing code in the properties box under properties/Value/Edit, then I tried it in the Script Editor. Example code: (Process Title being the name of my control): [Process Title]=UCase("& [Process Title] &"). No luck. Any ideas? Russ
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| MessageClass Property of a Post | Geoff | Outlook and VBA | 13 | June 27th 06 09:49 AM |
| How to change InternetCodepage property? | Konstantin Sokolovskiy | Outlook - General Queries | 0 | June 21st 06 01:17 PM |
| Auto correct the accidental use of cAPS LOCK. not working | swoffa | Outlook - General Queries | 2 | June 1st 06 02:49 AM |
| Auto correct the accidental use of cAPS LOCK. not working | swoffa | Outlook - General Queries | 2 | May 26th 06 05:22 AM |
| How to validate a Custom Property Page | Jack Zhang | Add-ins for Outlook | 1 | February 9th 06 08:22 PM |
Hybrid Mode
