Form: Subtraction

[Guest]

On a form, I have a text box that calculates the sum of some other numbers(TotalPaid). That works. There is another field where the user can enter the AmountPaid. That works. In the third field (BalanceDue), I want to calculate TotalPaid-AmountDue, but if TotalPaid=$130, AmountPaid = $10, the BalanceDue field states "$130,120.00" (I have in BalanceDue, the formula: =TotalPaid-AmountPaid. I don't want the "130" to display. I just want BalanceDue to display "$120.00". How???

 

[Graham Mayor]

Text Box? Don't use text boxes. Use frames or table cells.
Using your figures and bookmark names, the fields calculate correctly here.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>><

 

[Word Heretic]

G'day "Cathy" <cathykleinsmith(removethis)@aol.com>,

Do both referenced fields have number format and the same $ format
selected?

Steve Hudson - Word Heretic
Want a hyperlinked index? S/W R&D? See WordHeretic.com

steve from wordheretic.com (Email replies require payment)