Disable display of 0 in Auto-Calculated Form Fields

[Joshua]

I create a Purchase Requisition form to replace the paper version. There are
text box's for Quantity, Price and Amount.

The Amount text box has calculation to multiply the text box's of Quantity
and Price.

What happens is that even if the other two fields are blank it always has a
$0.00 in the Amount text box. If there is data in one of the other two
fields it calculate's correctly.

Now if this was excel it would be as simple using an IF command to check for
absence of data. Is there a calc formula I can use that would fix this or am
I stuck with 0's

I've uploaded the file to my site in case you guys would like to see an
example.

www.glumlord.com/files/Purchase Requisition.dot

If you dont feel comfortable opening a word document from web I have also
included screenshots of what I'm talking about.

www.glumlord.com/files/example1.PNG
www.glumlord.com/files/example2.PNG

Thanks,

Joshua

 

[Doug Robbins - Word MVP]

Add the following formatting switch to the Amount field \#
"$,0.00;($,0.00);"

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Joshua]

I tried to change then Number Format to \# "$,0.00;($,0.00);" and sure enough
it got rid of the 0's but it wont calculate now. For example if I put 1 in
the quantity and 5 in the price it just displays / $,0 in the Text Box.

I tried a number formats on my own but gave up a few months ago and told the
user to live with the 0's or no calculation

Hopefully we can get this figured out

 

[Doug Robbins - Word MVP]

Where did you put the \# "$,0.00;($,0.00);"

It works for me when it is located as follows

{ FORMTEXT { =Text1*Text2 } \# "$,0.00;($,0.00);" }

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Joshua]

I was putting it in the Number format, didn't realize you wanted me to
hit f9 and edit the field value

Your suggestion seems to be working, and my employee will be very happy

Thanks alot Doug, I really appreciate your time.

Joshua