form- how to make calculated field blank by default

J

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
 
D

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
 
J

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
 
G

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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top