[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

How to format a calculated field on an Outlook form

Posted on 2007-03-21
1
Medium Priority
?
504 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
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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

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…
Take a look at these 6 Outlook Email management tools which can augment the working and performance of Microsoft Outlook to give you a more rewarding emailing experience.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
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: …
Suggested Courses

831 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