Hi Jlawson,
Ok, i got the formula to work but it gives me error messages when i
have the REF form field blank or in a dollar amount. Is there a way
around this?
Well, for the blank form field you could set a default value of 0. And
you could try setting the FORMAT property to "0" or "0.00" so that
dollar signs (or any other kind of text) won't be allowed.
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail :-)