Word Form -- numeric fields miscalculate

macropod · #1 08-25-2016, 03:44 PM

Quote:

Originally Posted by snowboarder2

If the end user wants to enter data vertically in one column at a time, it's not going to calculate in all fields.

That would only be the case if you don't have the 'calculate on exit' property set for all of the cells involved in the calculations. Since your document is password-protected, I can't really see what you have there. And, given the structure of your form (which has a bunch of other formfields after the data to be calculated), if you had the 'calculate on exit' property set for all of the cells involved in the calculations, you probably wouldn't need the 'Click to insure all totals calculate' checkbox.

lboogy202 · #2 12-13-2020, 10:52 PM

I was having the same problem with the formfield for totalling multiple amounts doubling. I calculated the three bookmarked fields as normal then divided it by 2 and it worked (a suggestion from my son)

Example:
(AmountA+AmountB+AmountB)/2

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Legacy Form Fields Miscalculate	LauraL	Word	2	09-21-2015 08:47 PM
Macro to keep formatted form fields after mail merge or replace text with formatted form fields	jer85	Word VBA	2	04-05-2015 10:00 PM
Extract form fields to Word Document	RonNCmale	Word VBA	22	01-11-2014 05:06 AM
Form Fields in Word	jwm1346	Word	1	04-17-2012 07:02 PM
Form fields in Word messed up	mba	Word VBA	0	02-07-2010 09:54 PM