Solved

Change Outlook 2010 Field on Custom Form to Uppercase

Posted on 2013-05-29
5
811 Views
Last Modified: 2013-05-30
In Outlook 2010 I have a custom form.  On this form I have a field named "For".  In this field my user enters someone's initials and I want this field to always show as uppercase regardless of how my user enters it.

This should be easy to do, but I cannot get it to work.  In researching this, I found you can use this formula on the Value tab of the control for that field:

UCase([For])

I'm not sure where on the value tab to place this to get it to work.

I'm open to any suggestions.

Thanks in advance!
0
Comment
Question by:Senniger1
  • 3
  • 2
5 Comments
 
LVL 76

Expert Comment

by:David Lee
ID: 39204991
Hi, Senniger1.

When you say that the field is named "FOR", are you referring to the name of the control or the name of the field the control is connected to?
0
 

Author Comment

by:Senniger1
ID: 39205020
Actually it is both in my case, but for this purpose the name of the control is "For".  I created this field for this form (Type=Text and Properto to use=Value).
0
 
LVL 76

Accepted Solution

by:
David Lee earned 500 total points
ID: 39205674
Ok.  You'll need to add some code to the form to accomplish what you want.  Here's how to do that.

1.  Open the form in the form editor
2.  Click the "View Code" button the ribbon
3.  Copy and paste the code into the script editor
4.  Close the script editor
5.  Publish the form

The conversion to upper-case will not happen until you leave (e.g. click or tab out) the "For" field.  That's when the CustomPropertyChange event fires.  There is no way I know of to do this while typing since that action doesn't trigger any event we can trap and take some action on.

Sub Item_CustomPropertyChange(ByVal Name)
    If Name = "For" Then Item.UserProperties("For") = UCase(Item.UserProperties("For")) 
End Sub

Open in new window

0
 

Author Closing Comment

by:Senniger1
ID: 39207400
Exactly what I needed.  Thank you!
0
 
LVL 76

Expert Comment

by:David Lee
ID: 39207463
You're welcome!
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

If you don't know how to downgrade, my instructions below should be helpful.
Large Outlook files lead to various unwanted errors and corruption issues. Furthermore, large outlook files can also make Outlook take longer to start-up, search, navigate, and shut-down. So, In this article, i will discuss a method to make your Out…
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question