Hidding Blank Calculations in Word 2007

[Ben]

Hi,

I have a word 2007 template that I will be using to produce quotes.

In part of the form there are 4 lines for each tem that might be
quoted on, each line has 4 text form fields, each text form fields in
each line ends 1, 2 ,3, 4 i.e. quantity1, description1, unit_price1,
total_price1, then quantity2, description2, unit_price2, total_price2
etc.

If the text form fields are blank, I don't want them to show up when
printed out, which is what happens if there is no default text in the
form field, such as the description fields, but when you enter a
calculation, such as in total_price which would be "= quantity *
unit_price", it shows as £0.00 even if quantity & unit_price are
blank.

Is it possible to hid a calculation when its blank, rather than have
it display a null vlaue?

Thanks

Ben

[Doug Robbins - Word MVP]

Use the following type of field construction

{ IF { FORMTEXT { =Text1 * Text2 } \# �,0.00 } = "�0.00" "" { FORMTEXT {
=Text1 * Text2 } \# �,0.00 } }

You must use Ctrl+F9 to insert each pair of field delimiters { } and use
Alt+F9 to toggle off their display

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.
"Ben" <bjbla...@hotmail.com> wrote in message
news:90f743ad-c87c-45ee...@37g2000yqm.googlegroups.com...

[macropod]

Hi Doug,

There you go making it dificult again ...
{=Text1*Text2 \# \# "�ｿｽ,0.00;-�ｿｽ,0.00;"}

--
Cheers
macropod
[Microsoft MVP - Word]

"Doug Robbins - Word MVP" <d...@REMOVECAPSmvps.org> wrote in message news:%23jMOCHn...@TK2MSFTNGP04.phx.gbl...

> Use the following type of field construction
>

> { IF { FORMTEXT { =Text1 * Text2 } \# �ｿｽ,0.00 } = "�ｿｽ0.00" "" { FORMTEXT { =Text1 * Text2 } \# �ｿｽ,0.00 } }

>
> You must use Ctrl+F9 to insert each pair of field delimiters { } and use Alt+F9 to toggle off their display
>
> --
> Hope this helps,
>
> Doug Robbins - Word MVP
>
> Please reply only to the newsgroups unless you wish to obtain my services on a paid professional basis.
> "Ben" <bjbla...@hotmail.com> wrote in message news:90f743ad-c87c-45ee...@37g2000yqm.googlegroups.com...
> Hi,
>
> I have a word 2007 template that I will be using to produce quotes.
>
> In part of the form there are 4 lines for each tem that might be
> quoted on, each line has 4 text form fields, each text form fields in
> each line ends 1, 2 ,3, 4 i.e. quantity1, description1, unit_price1,
> total_price1, then quantity2, description2, unit_price2, total_price2
> etc.
>
> If the text form fields are blank, I don't want them to show up when
> printed out, which is what happens if there is no default text in the
> form field, such as the description fields, but when you enter a
> calculation, such as in total_price which would be "= quantity *

> unit_price", it shows as �ｿｽ0.00 even if quantity & unit_price are

[Doug Robbins - Word MVP]

macropod wrote:
> Hi Doug,
>
> There you go making it dificult again ...

> {=Text1*Text2 \# \# "�,0.00;-�,0.00;"}
>
Only because on the machine on which I was trying it, I was getting a
Syntax error message. But now when I use your construction (minus the
second \#, which causes a Too many picture switches error message) it works.

I have no idea why what I had tried earlier did not work, but will try
it again when I get to that machine.

[macropod]

Hi Doug,

Yes, that should have been:
{=Text1*Text2 \# "�,0.00;-�,0.00;"}
My bad.

--
Cheers
macropod
[Microsoft MVP - Word]

"Doug Robbins - Word MVP" <d...@REMOVECAPSmvps.org> wrote in message news:O6SHPh3X...@TK2MSFTNGP06.phx.gbl...

[Doug Robbins - Word MVP]

And of course, I cannot replicate the error that I was getting the other
day.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"macropod" <macr...@invalid.invalid> wrote in message
news:eg4ThUCY...@TK2MSFTNGP02.phx.gbl...

[macropod]

Hi Doug,

Perhaps you'd forgotten to enclose the switch expression with double quotes, which you can often get away with for just the standard
single-format expression.

--
Cheers
macropod
[Microsoft MVP - Word]

"Doug Robbins - Word MVP" <d...@REMOVECAPSmvps.org> wrote in message news:eAycghOY...@TK2MSFTNGP06.phx.gbl...