[JustMe]

I've created a form that calculates several fields based on the values input
in other fields. Because I am designing the form to be either printed and
filled out by hand or filled in using the computer I want the field to be
empty at the start. Right now I get 0.00 in them but this needs to be blank
if the user wanted to print and fill out by hand

[Doug Robbins - Word MVP]

With the document unprotected press Alt+F9 to toggle on the display of the
formfields and add the following formatting switch inside the last } of the
calculated formfield

\# "0.00;-0.00; "

Alt+F9 again and then protect your document

--
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
"Justme" wrote in message
...
I've created a form that calculates several fields based on the values
input
in other fields. Because I am designing the form to be either printed and
filled out by hand or filled in using the computer I want the field to be
empty at the start. Right now I get 0.00 in them but this needs to be
blank
if the user wanted to print and fill out by hand

[JustMe]

thanks but not quite yet. This is what I have in there now
{formtext {=text12*3 }\# 0.00;-0.00; "}
but it still shows 0.00 when i open the form even though nothing has been
entered in the text12 field. What I need is if the text12 field is blank then
this field should also be blank
Cindy

"Doug Robbins - Word MVP" wrote:

With the document unprotected press Alt+F9 to toggle on the display of the
formfields and add the following formatting switch inside the last } of the
calculated formfield

\# "0.00;-0.00; "

Alt+F9 again and then protect your document

--
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
"Justme" wrote in message
...
I've created a form that calculates several fields based on the values
input
in other fields. Because I am designing the form to be either printed and
filled out by hand or filled in using the computer I want the field to be
empty at the start. Right now I get 0.00 in them but this needs to be
blank
if the user wanted to print and fill out by hand

[Graham Mayor]

It works for me

{ FORMTEXT { =Text12 * 3 } \# "0.00;-0.00; "}

Make sure that having added the switch, you update the field.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Justme wrote:
thanks but not quite yet. This is what I have in there now
{formtext {=text12*3 }\# 0.00;-0.00; "}
but it still shows 0.00 when i open the form even though nothing has
been entered in the text12 field. What I need is if the text12 field
is blank then this field should also be blank
Cindy

"Doug Robbins - Word MVP" wrote:

With the document unprotected press Alt+F9 to toggle on the display
of the formfields and add the following formatting switch inside the
last } of the calculated formfield

\# "0.00;-0.00; "

Alt+F9 again and then protect your document

--
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
"Justme" wrote in message
...
I've created a form that calculates several fields based on the
values input
in other fields. Because I am designing the form to be either
printed and filled out by hand or filled in using the computer I
want the field to be empty at the start. Right now I get 0.00 in
them but this needs to be blank
if the user wanted to print and fill out by hand

[JustMe]

Today it works. I was updating the field. Maybe it was a space somewhere
thanks

"Graham Mayor" wrote:

It works for me

{ FORMTEXT { =Text12 * 3 } \# "0.00;-0.00; "}

Make sure that having added the switch, you update the field.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Justme wrote:
thanks but not quite yet. This is what I have in there now
{formtext {=text12*3 }\# 0.00;-0.00; "}
but it still shows 0.00 when i open the form even though nothing has
been entered in the text12 field. What I need is if the text12 field
is blank then this field should also be blank
Cindy

"Doug Robbins - Word MVP" wrote:

With the document unprotected press Alt+F9 to toggle on the display
of the formfields and add the following formatting switch inside the
last } of the calculated formfield

\# "0.00;-0.00; "

Alt+F9 again and then protect your document

--
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
"Justme" wrote in message
...
I've created a form that calculates several fields based on the
values input
in other fields. Because I am designing the form to be either
printed and filled out by hand or filled in using the computer I
want the field to be empty at the start. Right now I get 0.00 in
them but this needs to be blank
if the user wanted to print and fill out by hand