Calculating in protected word form

I designed a word document with calculated fields.  The fields that I wanted to calculate I ticked “Calculate on Exit”.  Under Number format I selected 0.00 for all the fields that I want to calculate.  I protected the form for filling in forms.  When I use it as a protected form I type in 4.50 text defaults to 4.  When I remove the protection I noticed that under property all the Number Formats have (0.00) has been lost.

 

Grr!

 

Will appreciate assistance

 

Question Info


Last updated December 15, 2017 Views 339 Applies to:
Answer

That's a bug in Word 2010.

 

You will need to run a macro containing the following code on exit from each such formfield

 

With ActiveDocument.FormFields(Selection.Bookmarks(Selection.Bookmarks.Count).Name)
    .Result = Format(.Result, "0.00")
End With

Hope this helps,
Doug Robbins - Word MVP
dougrobbinsmvp@gmail.com
MY EMAIL ADDRESS IS VISIBLE FOR A REASON
OneDrive Link for documents to be recovered
https://1drv.ms/f/s!AmuIXmFDy-1a8nP3RpgnYHp-5zXK

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.