Solved

Change Outlook 2010 Field on Custom Form to Uppercase

Posted on 2013-05-29
5
793 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Resolve DNS query failed errors for Exchange
Resolve Outlook connectivity issues after moving mailbox to new Exchange 2016 server
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…
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…

896 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now