Solved

Change Outlook 2010 Field on Custom Form to Uppercase

Posted on 2013-05-29
5
789 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Exactly what I needed.  Thank you!
0
 
LVL 76

Expert Comment

by:David Lee
Comment Utility
You're welcome!
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Resolve DNS query failed errors for Exchange
Resolve Outlook connectivity issues after moving mailbox to new Exchange 2016 server
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

743 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

16 Experts available now in Live!

Get 1:1 Help Now