Prev: Office Supplemental Release (October 2009)
Next: run macro after userform unloads
From: Kay on 21 Dec 2009 22:46
I have a form in Word 2003 that will serve two purposes. It can be filled
out electronically or printed and hand-written. I am using a calculated
field, but do not want the "0" to print when it is used as a hand-written
doc. Suggestions appreciated.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/community/en-us/default.mspx?mid=80eca999-1452-43f8-9f57-6204d46709c7&dg=microsoft.public.word.vba.general
From: Doug Robbins - Word MVP on 21 Dec 2009 23:23
After setting up your calculation type formfield, but before protecting the
document for filling in forms, use Alt+F9 to toggle on the display of the
field codes and add the \# "0;-0; " formatting switch

{ FORMTEXT { [Your Formula] \# "0;-0; " } }

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"Kay" <Kay(a)discussions.microsoft.com> wrote in message
news:80ECA999-1452-43F8-9F57-6204D46709C7(a)microsoft.com...
>I have a form in Word 2003 that will serve two purposes. It can be filled
> out electronically or printed and hand-written. I am using a calculated
> field, but do not want the "0" to print when it is used as a hand-written
> doc. Suggestions appreciated.
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow
> this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=80eca999-1452-43f8-9f57-6204d46709c7&dg=microsoft.public.word.vba.general

 | 
Pages: 1
Prev: Office Supplemental Release (October 2009)
Next: run macro after userform unloads