Calculation field error

M

moombi

I used the following to info to hide the zero but when I do the number shows
up twice. What am I doing wrong? Here is what I have

{=(siteoffsitecost+bldgcost+misccost)\#"$,#.##;($,#.##);"}

and I am getting this result:

$265,687.79$265,687.79

DomMar,

You can use a regulare formula field (vice calculation field) with a numeric
switch to hide the zero.
Example. Say you have Text1 and Text2 as the varialbles. Set both to
calculate on exit. Enter the following formula field.
{ =(Text1+Text1) \# "#;-#; " }
Note the field braces { } are entered with CTRL+F9. Once you have the
field entered then toggle the code and protect the form.
Greg Maxey/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

Similar Threads

MS word update field problem 1
calculation in word form template 1
If calculation in text box > 1 hour set check box = True 2
Problem with conditional calculation in a table 3
Carriage Return Symbol Text Field Word Form VBA Problem inside Tab 2
Calculation using 2 other form fields (word 2002) 4
calculate on exit/macro exit 6
Calculate text1 * text2 and output into text3 10

Top