Script for SLiding/Printing possible ?

[corey]

I was after, if possible, a script or some way to have TEXT not printed if a field calculation was not used.

If that particular calc. is used then the TEXT will show/print.

EG. PRINT VIEW

2hrs X $50.00p/hr= $100.00 CALC USED

CALC NOT USED

If there is NO input for the Calc to be used (not needed), then the X & the = will not be printed.

The reason i want to do this is for a QUOTE FORM.

When certain aspects (fields) are not used then i dont want to see the multiplication and equalls signs on the layout when it is not required for that particular QUOTE.

Any help would be appreciated.

[Lee Smith]

Use the IsEmpty with your calculation.

In other words:

Case(IsEmpty(FIELDWITHCALC), "",

"2hrsX $50.00p/hr=$100.00")

Sub your own field for FIELDWITHCALC and adjust the 2hrsX $50.00p/hr=$100.00 part so that it matches fields or quotes, etc.

HTH

Lee