What causes the "Calculate on Exit" FormField function to stop working?

Posted on 2009-04-16
Last Modified: 2012-05-06
I have a Word 2007 document controlled by a lot of VBA including FormFields making use of the "Calculate on Exit" function.  "Calculate on Exit" worked as expected.  I then copied the document and made extensive changes to the VBA.  The changes to the VBA worked properly but somewhere along the way, "Calculate on Exit" stopped working throughout the document.  I rolled back the VBA changes but the problem didn't go away.  I then changed the Word 2007 options in the after version of the document to match the before version and the problem still didn't go away.

I am now stumped.  Does anyone have any ideas?  I suspect that I am missing something obvious.

Trying to roll all the changes forward starting with the working document to the current state of the project would be a HUGE amount of work.  Help!
Question by:TimLitle
    LVL 76

    Expert Comment

    It sounds as if the document might be corrupt. Try copying and pasting it to a new blank document.
    LVL 76

    Accepted Solution

    It sounds as if the document might be corrupt. Try copying and pasting it to a new blank document.
    LVL 37

    Assisted Solution

    by:Joanne M. Orzech
    Have you also tried deleting the formfield entirely and recreating it... the one you're having the problem with... or is it ALL formfields that won't calculate on exit?

    Are the macros that are running on exit named the same?  Perhaps they got renamed or mistyped somehow?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    Nice table. Huge mess. Maybe this was something you created way back before you figured out tabs or a document you received from someone else. Either way, using the spacebar to separate the columns resulted in a mess. Trying to convert text to t…
    This is written from a 'VBA for MS Word' perspective, but I am sure it applies to most other MS Office components where VBA is used.  One thing that really bugs me is slow code, ESPECIALLY when it's mine!  In programming there are so many ways to…
    This video teaches the viewer how to align pictures around text while keeping the text properly aligned in the document.
    Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now