 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Document Management / July 2008Calculations in forms
I have a word document that I put the form fields in. I have numbers being entered in and then I want to calculate at the bottom. I put in another field and put calculations. Is this the right way? Could someone please guide me? Thanks Cheyenne Yes, use a calculation-type form field and be sure to check the box for "Calculate on exit" for each of the form fields that contributes to the calculation.  SignatureSuzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA >I have a word document that I put the form fields in. I have numbers being > entered in and then I want to calculate at the bottom. I put in another [quoted text clipped - 4 lines] > Thanks > Cheyenne How do I get it to calculate though right now I have =text3+text4 but it calculates 0 even though I have a 5 in text3 and a 4 in text4. Will it not automatically update itself? That is really what I need it to do? > Yes, use a calculation-type form field and be sure to check the box for > "Calculate on exit" for each of the form fields that contributes to the [quoted text clipped - 8 lines] > > Thanks > > Cheyenne Double-click the Text3 formfield to open the Form Field Options dialog and check the box for "Calculate on exit." Do the same for Text4. Then protect the form. When you enter data in those two fields, you calculation will be updated. Note, however, that only a tab out of the field will be recognized as "exit"; just clicking somewhere else doesn't suffice. SignatureSuzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA > How do I get it to calculate though right now I have =text3+text4 but it > calculates 0 even though I have a 5 in text3 and a 4 in text4. Will it not [quoted text clipped - 13 lines] >> > Thanks >> > Cheyenne Thanks I got it. > Double-click the Text3 formfield to open the Form Field Options dialog and > check the box for "Calculate on exit." Do the same for Text4. Then protect [quoted text clipped - 19 lines] > >> > Thanks > >> > Cheyenne How do I do the macro for entry? Will that update the calculations? > Yes, use a calculation-type form field and be sure to check the box for > "Calculate on exit" for each of the form fields that contributes to the [quoted text clipped - 8 lines] > > Thanks > > Cheyenne You would only need a macro to update fields if you were using a Word field in the header/footer to create or reproduce the calculation. If you were to need such a macro, you can use the sample code at http://www.gmayor.com/installing_macro.htm Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > How do I do the macro for entry? Will that update the calculations? > [quoted text clipped - 16 lines] >>> Thanks >>> Cheyenne |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.