?
Solved

How to format a calculated field on an Outlook form

Posted on 2007-03-21
1
Medium Priority
?
499 Views
Last Modified: 2011-01-09
Creating an Outlook form, and in using a formula to calculate a field, I cannot figure out how to apply a format to the field.  Example: I am multiplying a price and a quantity to yield a total cost.  The result is unformatted, so it shows "6" instead of $6.00.  I am using Outlook 2003 on Windows XP Pro.

Thanks
0
Comment
Question by:Damian_Gardner
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 76

Accepted Solution

by:
David Lee earned 2000 total points
ID: 18870536
You need to add some code to the form to handle this.  Something like this:

Sub Item_CustomPropertyChange(ByVal Name)
    Dim olkInspector, olkPage
    Set olkInspector = Item.GetInspector
    'Change the page name on the next line as needed
    Set olkPage = olkInspector.ModifiedFormPages("Message")
    'Change the property name on the next two lines as needed
    If Name = "YourPropertyName" Then
        Item.UserProperties("YourPropertyName").Value = FormatNumber(Item.UserProperties("YourPropertyName").Value,2,False,False,True)
    End If
    Set olkPage = Nothing
    Set olkInspector = Nothing
End Sub
0

Featured Post

Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

Question has a verified solution.

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

Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
In this article I discuss my selections of the Top Four free Outlook OST File Viewers available. Open, view and read even damaged OST files by using these tools. They all provide a clear preview of all data such as emails, notes, tasks, calendars, e…
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
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…
Suggested Courses

765 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