Nested Set & Formula Fields in Word 97

B

Bob Estes

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.
 
D

Doug Robbins - Word MVP

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


--
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top