Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Creating Calculations in Text Form Fields (Word XP/SP3)

    I have created a locked form (created w/ a table and text form fields), in which I have four or five text fields that contain calculations. The calculations/formulas work fine when the form is not locked (using F9 to update), but once I lock the form, the user is not even able to tab to those fields (they are skipped right over and NOT calculated). Any idea, first, why those fields are not tabbed to and, second, how I might make this form different (other than in Excel) to work properly...? I can send/attach the form, if necessary. Thanks so much for any advice!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Creating Calculations in Text Form Fields (Word XP/SP3)

    If you set the Type property of a text form field to Calculated, the Fill-in enabled property is automatically turned off (and the check box for this property is disabled)

    To have the calculation work, double click each form text box that contributes to the result of the calculation, and tick the Calculate on Exit check box.

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Creating Calculations in Text Form Fields (Word XP/SP3)

    That did it! I had already tried this option, but had checked the "Calculate on Exit" check box for the fields where the result was to be calculated rather than for the fields that contribute to the result. I was just missing that step/association. Thanks so much - you've saved the day! [img]/forums/images/smilies/smile.gif[/img]

  4. #4
    Lounger
    Join Date
    May 2004
    Location
    Chicago, Illinois, USA
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Creating Calculations in Text Form Fields (Word XP/SP3)

    Awesome... was just having this same problem. Did not realize each contributing cell needed that property. Thanks once again HansV!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •