blank when zero

[Jean-Guy Marcil]

Bonjour,

Dans son message, < macropod > écrivait :

Hi Jean-Guy Marcil,

While you may not be able to hide a calculated Form Field, why would you

use

I was able to with a lot of ease, once you know how!

Just because! Greg was curious as to how it could be done, and he
thought it could not be done. Se we just looked for a way to do it.

one when a simple formula field can return the desired result with a lot
less fiddling? What I showed is how to use a standard formula field to take
the output from two Form Fields and give a 'correct' result when either or
both Form Fields is empty.

The format/forms of the numbers used to perform the calculation was
irrelevant to the discussion. We were just concerned by the result itself.:
How to hide a calculated formfield if its calculated result is "0"
(Regardless of how that result was achieved)?

Of course you are right, "normal" formula field are much easier and I
usually use those as well.
It was just a discussion for the sake of it. I.e "I think it cannot be
done." "Yes, it can, here's how"

;-)


--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[macropod]

Hi,

A bit like climbing a mountain then: Because it's there!

Salut