Form: Subtraction


G

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

Advertisements

G

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

Advertisements

W

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)
 

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