If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Getting a table to total columns
In that case plan B. Replace the calculated formfield with a conditional
field. If the field bookmark names remain A1 & A2 { IF{ ={ A1 } * { A2 } } 0 { ={ A1 } * { A2 } \# "0.00"} } Set the switch \# "0.00" appropriate to your needs The field will show a syntax error if there is no value in A1 or A2, so set those field types to number and put a default 0 in each. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Willem Nel wrote: 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. 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! |
Thread Tools | |
Display Modes | |
|
|