Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculation field error
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help! I'm getting error messages too much-can't open Resume Wizard | Microsoft Word Help | |||
How to make a Calculation field to show blank | Tables | |||
Field code error when printing document | Microsoft Word Help | |||
If field calculation | Microsoft Word Help | |||
field calculation error, mailmerge, | Mailmerge |