Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
LeahT LeahT is offline
external usenet poster
 
Posts: 42
Default Simple formula issue...forms

Okay...soooo I have a form (we know this because I have asked a million
questions about it already). I have 3 text/number fields that I need to
automatically add together in the forth field/cell...how do I do that!?

For example Text68+Text69+Text70 and the answer shows up as the person
exits Text70 in Text 71

Any thoughts!?
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Greg Maxey Greg Maxey is offline
external usenet poster
 
Posts: 285
Default Simple formula issue...forms

Text71 should be of the field type calculation. Enter in the expression
field
=(Text68+Text69+Text70)

If you only want to see the updated result on exit of Text70 then set
"calculate on exit" in Text70. You would be better off to set "calculate on
exit" for Text68, Text69 and Text70.

To make these setting, unprotect the form and double click the formfields.
This opens the formfields dialog box.

--
Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.

"LeahT" wrote in message
...
Okay...soooo I have a form (we know this because I have asked a million
questions about it already). I have 3 text/number fields that I need to
automatically add together in the forth field/cell...how do I do that!?

For example Text68+Text69+Text70 and the answer shows up as the person
exits Text70 in Text 71

Any thoughts!?



  #3   Report Post  
Posted to microsoft.public.word.docmanagement
LeahT LeahT is offline
external usenet poster
 
Posts: 42
Default Simple formula issue...forms

Okay...that is what I get for trying to go back in the old posts to figure
this out before posting! Thank you for the help!

"Greg Maxey" wrote:

Text71 should be of the field type calculation. Enter in the expression
field
=(Text68+Text69+Text70)

If you only want to see the updated result on exit of Text70 then set
"calculate on exit" in Text70. You would be better off to set "calculate on
exit" for Text68, Text69 and Text70.

To make these setting, unprotect the form and double click the formfields.
This opens the formfields dialog box.

--
Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.

"LeahT" wrote in message
...
Okay...soooo I have a form (we know this because I have asked a million
questions about it already). I have 3 text/number fields that I need to
automatically add together in the forth field/cell...how do I do that!?

For example Text68+Text69+Text70 and the answer shows up as the person
exits Text70 in Text 71

Any thoughts!?




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Forms Development in Word Jugglertwo Microsoft Word Help 2 February 1st 06 05:36 PM
printing forms Kagiso Microsoft Word Help 2 December 14th 05 10:21 PM
printing only forms Kagiso Microsoft Word Help 1 December 14th 05 04:32 PM
Formula to Sum values in word table Craig Mailmerge 1 August 29th 05 06:19 PM
making simple forms like lists Ren Microsoft Word Help 1 May 12th 05 08:31 PM


All times are GMT +1. The time now is 08:04 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"