Field Switched

[Kay]

Hello,
I have a syntax error in a Word 2003 calculated form control. I have read
many of the articles suggested here when dealing with field switches, etc.,
but keep getting the syntax error.

Here is what I am doing and why. Creating a form that will be used by very
inexperienced computer users. Some may fill out the form electonically, thus
the form fields, others will print it out and fill it in. It must be as
simple as possible.

verification field with number fields set to calculate on exit and a total
calculated field which shows a zero by default. We cannot have the zero show
in case the form is printed and filled out by hand. I added the following to
the field code; {formtext{=sum(above)\# "$,0.00;($,0.00);"}} but all I get is
!Syntax Error, #

If you could so graciously help me figure out the syntax to hide the 0 I
would appreciate it.
Thanks!

 

[Doug Robbins - Word MVP]

That field switch works fine here. I assume that all of the { } were not
entered from the keyboard.

--
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, originally posted via msnews.microsoft.com

 

[macropod]

Hi Kay,

Instead of trying to embed a formula field in a formfield, you could use a formula field coded as:
{=sum(above) \# "$,0.00;($,0.00);"}

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.