View Single Post
  #20  
Old June 6th, 2009, 12:10 AM posted to microsoft.public.word.tables
Willem Nel
external usenet poster
 
Posts: 12
Default Getting a table to total columns

I found the selution through trial and error.

{ FORMTEXT { =A1 * A2 } \# #;-#; } and not { FORMTEXT { =A1 * A2 } \# 0;-0;
} or the IF option.

Thanks for your inputs. It has helped me to get to the selution, believe it
or not.
--
Wllem Nel


"Doug Robbins - Word MVP" wrote:

With the document unprotected, press Alt+F9 to toggle the display of the
field codes and modify the calculation field to the following

{ FORMTEXT { =A1 * A2 } \# 0;-0; }

You can replace the 0 with whatever format you require for the result

e.g. 0.00;(0.00);

etc.

--
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
"Willem Nel" wrote in message
...
Thanks Doug!!! Form calculations now running smooth! Need one more input
from
you, please. How do I get the result of a calculation to not show 0. I
want
the field to be blank if result is 0.


--
Wllem Nel


"Doug Robbins - Word MVP" wrote:

Insert Text Input FormFields in A1 and A2 and set the Calculate on Exit
property of each. Assuming that you name bookmarks assigned to those
fields
as A1 and a2, in A3, insert a calculation type formfield that contains
the
expression =A1 * A2

See the following;

http://www.mousetrax.com/techpage.html#autoforms
Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time and keep
better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136


--
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
"Willem Nel" wrote in message
...
In tables in word:

A1 =2 A2=4 A3= SUM(LEFT) OR A1*A2
All formulas work is template mode if number in A1 AND A2 is recorded
when
formula is set. There after ctrl+a, f9 updates field in template. If
template
is protected or saved as word document A3 never changes when A1 OR A2
changes. Ctrl+a, F9 or right click also does not work. Form with
calculation
of no use to customers or our company! Need to get A3 formula to
automaticly
update when A1 OR A2 changes if template is protected or saved as word
document. See book-keeping slip template under forms on online
templates.
This is what formulas should do! Book-keeping slip is protected and
cannot
see formula!

--
Wllem Nel


"Doug Robbins - Word MVP" wrote:

Can you provide more details of what you want to do?

--
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
"Willem Nel" wrote in message
...
Ctrl+A, F9 works in template (not protected). When the form is with
a
customer or user no formulas operates the way it shoud. I have
studied
template online tutorials etc. Could not find a solution. Can any
one
help?
--
Wllem Nel


"RichardB43" wrote:

"Suzanne S. Barnhill" wrote:

This isn't any different from previous versions, is it?

Like everything else in the new version (I've used it maybe 1 year
now,
still find it abysmal for navigation), it is a hell of a lot harder
to
find.

And even try searching for "formula" in help - nothing!

Lots of fancy stuff in the new version about making your document
look
pretty, but as for useability, it was a huge retrograde step!