View Single Post
  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Calculation form field won't update

You don't really need a form field for the calculation - use a Word formula
field instead
{={REF Bok_Benefit}/{REF Bok_Cost-1}}
Calculate on exit will force an update on such a field (unless it is in a
header/footer, when you need a macro run on exit from the field to update
it - eg the sample code at http://www.gmayor.com/installing_macro.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Impecunious wrote:
Hi,

I've got a calculation form field in Word that uses the formula
'=bok_benefit/bok_cost-1', where bok_benefit and bok_cost are two
other bookmarked text form fields. I've set both of these supporting
fields to "Calculate on exit", but for whatever reason, my
calculation field refuses to update when either of these fields are
modified. I can F9 the field and it'll update, but because this
document is going to be used as a form, I obviously don't users to
have to resort to this.

I'm trying to wrap up this form ASAP, and this problem is driving me
nuts. I'd definitely appreciate anyone's advice!