[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Word 2010 will not hold currency format

Posted on 2011-05-04
Medium Priority
Last Modified: 2012-05-11
Began to think that 2010 was a total waste of money. Far too many bugs in it with no solutions coming out. I can format a form fill field for currency but when I close and reopen the document, it has lost the currency format and only shows numbers. Apparently I am not the only one with this issue. You would think that Microsoft would have resolved this by now. Any ideas? May be time to bring back my Office 2007.
Question by:anaron
  • 3
  • 2
LVL 30

Expert Comment

ID: 35695590
>>>but when I close and reopen the document, it has lost the currency format and only shows numbers.

My Suggestion would be to insert this Macro in the Word Document 'Open' Event.

Private Sub Document_Open()
    Dim FF As FormField
    For Each FF In ActiveDocument.FormFields
        FF.Result = Format(FF.Result, "$#,###.00")
End Sub

Open in new window

Sample file attached.

LVL 30

Expert Comment

ID: 35695595
Please note that I had to attach it as an exe as .docx is not supported. Simply run the exe and extract the word document. Now when you open the document, you will see the form fields retain the formatting.

 [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


Author Comment

ID: 35696009
Sid, this is on a custom invoice so I need the fields to be blank until the info is entered. I want to type in the numbers say 320 and have it appear $320.00 or 2.5 and it appears $2.50 just like Word 2007 did. I can't get the example you sent to do that. I have very little knowledge of visual basic but looks as if I may have to learn just to get the programs to work the way I want.
LVL 30

Accepted Solution

SiddharthRout earned 2000 total points
ID: 35696073
In taht case there two things you need to take care of

1) When the document opens, if will check if the Form Field is empty or not. If it is not empty then format it else leave it alone

2) On the lost focus of the Form Field again check if the Form Field is empty or not. If it is not empty then format it else leave it alone.

If this is what you want then let me know and I will create an example for you.


Author Comment

ID: 35706660
Thanks very much Sid for you assistance. After hours of researching this issue, I have decided that this is getting far too complicated, especially for the bucks Office Pro 2010 costs. AND this is only one of a multitude of problems that apparently plague Office 2010. There is absolutely no reason I should have to get this deep into HACK fixing a problem that should not be a problem to begin with. The every day Office user just wants the program to work as Microsoft represented. My best solution is to go back to Office 2007 and go after Microsoft for a full refund (that'll be a trip!) on their DEFECTIVE program. It would be different if Microsoft was attempting to resolve the issues but they seem to be totally ignoring their screwups while expecting the consumer to just accept that this is the way it is. Might jsut be time for an OFFICE 2010 CLASS ACTION LAWSUIT!

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Lost Word File? Eagerly, need it back? Read ahead; this File Recovery guide is for you.
The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

834 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