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

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" <ruparker@indiana.edu> wrote in message news:1150914877.442593.140440@y41g2000cwy.googlegroups.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
>

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" <ruparker@indiana.edu> wrote in message news:1150914877.442593.140440@y41g2000cwy.googlegroups.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
> >

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" <ruparker@indiana.edu> wrote in message news:1150983384.456218.107390@u72g2000cwu.googlegroups.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" <ruparker@indiana.edu> wrote in message news:1150914877.442593.140440@y41g2000cwy.googlegroups.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
>> >
>

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" <ruparker@indiana.edu> wrote in message news:1150983384.456218.107390@u72g2000cwu.googlegroups.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" <ruparker@indiana.edu> wrote in message news:1150914877.442593.140440@y41g2000cwy.googlegroups.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
> >> >
> >

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" <ruparker@indiana.edu> wrote in message news:1150990184.291794.326800@g10g2000cwb.googlegroups.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" <ruparker@indiana.edu> wrote in message news:1150983384.456218.107390@u72g2000cwu.googlegroups.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" <ruparker@indiana.edu> wrote in message news:1150914877.442593.140440@y41g2000cwy.googlegroups.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
>> >> >
>> >
>

No typos or wrong field name, I created a brand new test textbox to use
as a test case, and the text I put into that field vanished too once I
tabbed out. There must be something that I've checked, or unchecked or
other minutiae that I'm not finding that are making this not work.
Thanks for your help.

Russ

Sue Mosher [MVP-Outlook] wrote:
> 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" <ruparker@indiana.edu> wrote in message news:1150990184.291794.326800@g10g2000cwb.googlegroups.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" <ruparker@indiana.edu> wrote in message news:1150983384.456218.107390@u72g2000cwu.googlegroups.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" <ruparker@indiana.edu> wrote in message news:1150914877.442593.140440@y41g2000cwy.googlegroups.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
> >> >> >
> >> >
> >

Works fine here every time. Note that the field in the formula needs to be the name of the Outlook property, not the name of a control. Maybe you can post a screen somewhere of your Value tab.

--
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" <ruparker@indiana.edu> wrote in message news:1150996481.367854.271490@b68g2000cwa.googlegroups.com...
> No typos or wrong field name, I created a brand new test textbox to use
> as a test case, and the text I put into that field vanished too once I
> tabbed out. There must be something that I've checked, or unchecked or
> other minutiae that I'm not finding that are making this not work.
> Thanks for your help.
>
> Russ
>
> Sue Mosher [MVP-Outlook] wrote:
>> Formula pointing to the wrong field? Typo in the field name?

>> "Russ" <ruparker@indiana.edu> wrote in message news:1150990184.291794.326800@g10g2000cwb.googlegroups.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" <ruparker@indiana.edu> wrote in message news:1150983384.456218.107390@u72g2000cwu.googlegroups.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" <ruparker@indiana.edu> wrote in message news:1150914877.442593.140440@y41g2000cwy.googlegroups.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
>> >> >> >
>> >> >
>> >
>

Alright, one last question (I hope). When I use UCase( [xxxx] ) for
pre-defined fields like subject, to, Cc, etc this function works just
fine and capitalizes the text. However, if I create a user-defined
field and try to use the UCase function, the text disappers from the
text box. Is more code needed in this case to point to the field? I'm
pretty much at a loss. I've been looking at outlookcode, but haven't
found anything specific yet. Thanks. Russ

Sue Mosher [MVP-Outlook] wrote:
> Works fine here every time. Note that the field in the formula needs to be the name of the Outlook property, not the name of a control. Maybe you can post a screen somewhere of your Value tab.
>
> --
> 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" <ruparker@indiana.edu> wrote in message news:1150996481.367854.271490@b68g2000cwa.googlegroups.com...
> > No typos or wrong field name, I created a brand new test textbox to use
> > as a test case, and the text I put into that field vanished too once I
> > tabbed out. There must be something that I've checked, or unchecked or
> > other minutiae that I'm not finding that are making this not work.
> > Thanks for your help.
> >
> > Russ
> >
> > Sue Mosher [MVP-Outlook] wrote:
> >> Formula pointing to the wrong field? Typo in the field name?
>
> >> "Russ" <ruparker@indiana.edu> wrote in message news:1150990184.291794.326800@g10g2000cwb.googlegroups.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" <ruparker@indiana.edu> wrote in message news:1150983384.456218.107390@u72g2000cwu.googlegroups.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" <ruparker@indiana.edu> wrote in message news:1150914877.442593.140440@y41g2000cwy.googlegroups.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
> >> >> >> >
> >> >> >
> >> >
> >

OK, I see now. I took the shortcut and just tried it with a built-in property, not a custom property. I don't know why it doesn't work with custom properties.

In any case, the other approach is to use code behind the form:

Sub Item_CustomPropertyChange(ByVal Name)
Select Case Name
Case "Process Title"
Item.UserProperties("Process Title") = _
UCase(Item.UserProperties("Process Title"))
' put more Case blocks here if you
' need to handle other properties
End Select
End Sub

See http://www.outlookcode.com/d/propsyntax.htm for more information on the CustomPropertyChange event. Note that code runs only on published forms.

--
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" <ruparker@indiana.edu> wrote in message news:1151437684.509462.94250@b68g2000cwa.googlegroups.com...
> Alright, one last question (I hope). When I use UCase( [xxxx] ) for
> pre-defined fields like subject, to, Cc, etc this function works just
> fine and capitalizes the text. However, if I create a user-defined
> field and try to use the UCase function, the text disappers from the
> text box. Is more code needed in this case to point to the field? I'm
> pretty much at a loss. I've been looking at outlookcode, but haven't
> found anything specific yet. Thanks. Russ
>
> Sue Mosher [MVP-Outlook] wrote:
>> Works fine here every time. Note that the field in the formula needs to be the name of the Outlook property, not the name of a control. Maybe you can post a screen somewhere of your Value tab.

>>
>> "Russ" <ruparker@indiana.edu> wrote in message news:1150996481.367854.271490@b68g2000cwa.googlegroups.com...
>> > No typos or wrong field name, I created a brand new test textbox to use
>> > as a test case, and the text I put into that field vanished too once I
>> > tabbed out. There must be something that I've checked, or unchecked or
>> > other minutiae that I'm not finding that are making this not work.
>> > Thanks for your help.
>> >
>> > Russ
>> >
>> > Sue Mosher [MVP-Outlook] wrote:
>> >> Formula pointing to the wrong field? Typo in the field name?
>>
>> >> "Russ" <ruparker@indiana.edu> wrote in message news:1150990184.291794.326800@g10g2000cwb.googlegroups.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" <ruparker@indiana.edu> wrote in message news:1150983384.456218.107390@u72g2000cwu.googlegroups.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" <ruparker@indiana.edu> wrote in message news:1150914877.442593.140440@y41g2000cwy.googlegroups.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
>> >> >> >> >
>> >> >> >
>> >> >
>> >
>