Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement,microsoft.public.word.tables
Ben[_5_] Ben[_5_] is offline
external usenet poster
 
Posts: 2
Default Hidding Blank Calculations in Word 2007

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
  #2   Report Post  
Posted to microsoft.public.word.docmanagement,microsoft.public.word.tables
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Hidding Blank Calculations in Word 2007

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" wrote in message
...
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

  #3   Report Post  
Posted to microsoft.public.word.docmanagement,microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Hiding Blank Calculations in Word 2007

Hi Doug,

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

--
Cheers
macropod
[Microsoft MVP - Word]


"Doug Robbins - Word MVP" wrote in message ...
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" wrote in message ...
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


  #4   Report Post  
Posted to microsoft.public.word.docmanagement,microsoft.public.word.tables
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Hiding Blank Calculations in Word 2007

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.

--
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.
  #5   Report Post  
Posted to microsoft.public.word.docmanagement,microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Hiding Blank Calculations in Word 2007

Hi Doug,

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

--
Cheers
macropod
[Microsoft MVP - Word]


"Doug Robbins - Word MVP" wrote in message ...
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.

--
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.




  #6   Report Post  
Posted to microsoft.public.word.docmanagement,microsoft.public.word.tables
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Hiding Blank Calculations in Word 2007

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" wrote in message
...
Hi Doug,

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

--
Cheers
macropod
[Microsoft MVP - Word]


"Doug Robbins - Word MVP" wrote in message
...
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.

--
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.



  #7   Report Post  
Posted to microsoft.public.word.docmanagement,microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Hiding Blank Calculations in Word 2007

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" wrote in message ...
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" wrote in message ...
Hi Doug,

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

--
Cheers
macropod
[Microsoft MVP - Word]


"Doug Robbins - Word MVP" wrote in message ...
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.

--
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.




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 2007 Table Calculations Mike Tables 4 October 10th 08 10:54 PM
calculations in Word 2007 tables juan Tables 2 August 14th 08 05:56 PM
Word 2007 Disable calculations billzinn Tables 2 June 27th 08 03:52 PM
add rows to word 2007 locked table w/ calculations nirie1 Tables 1 April 18th 07 05:52 PM
Hidding text in Word 2007 preeto New Users 2 December 19th 06 03:01 PM


All times are GMT +1. The time now is 04:35 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"