Nested Set & Formula Fields in Word 97

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob Estes - 29 May 2004 03:47 GMT

I have created a Real Estate Purchase & Sale Agreement as
a Word 97 online form, and now I am trying to automate
certain features. I am trying to set a bookmark where the
contents are the result of a calculation. Help shows an
example of a formula field nested in a set field, and
this is what I've tried.

{ SET Balance { = PurchasePrice - Deposit - Assumed -
PMM - Other }} {REF Balance \# $#,##0.00 \* MERGEFORMAT }

All of the Bookmarks in the formula field were
established by nesting an insert field inside a set field
which was then followed by a REF field. They all work
fine.

The problem is that when I test the form, all I get is
0.00 for a value of the Balance bookmark. Can any one
shed some light on what I'm doing wrong. I thank you in
advance for any help you can provide.

Reply to this Message

Doug Robbins - Word MVP - 29 May 2004 08:32 GMT

I've never heard of anyone trying to use such a method to perform
calculations with on online form. You will find the way that it is intended
to be done in the following series of articles

Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time and keep
better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> I have created a Real Estate Purchase & Sale Agreement as
> a Word 97 online form, and now I am trying to automate
[quoted text clipped - 15 lines]
> shed some light on what I'm doing wrong. I thank you in
> advance for any help you can provide.

Reply to this Message

Rate this thread: