Solved

Change Outlook 2010 Field on Custom Form to Uppercase

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Finding original email is quite difficult due to their duplicates. From this article, you will come to know why multiple duplicates of same emails appear and how to delete duplicate emails from Outlook securely and instantly while vital emails remai…
In this step by step procedure, you will come to know the details of creating an Outlook meeting in 2007, 2010, 2013 & 2016.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
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…

776 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