Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Menus and Toolbars / September 2005

Tip: Looking for answers? Try searching our database.

TOC breaks "Calculate on Exit" Function in Protected Forms

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Greg Maxey - 14 Sep 2005 22:54 GMT
Hello all,

I posted on this topic in the mailmerge.fields group earlier today and
thought I would post here for more exposure.  A visitor to one of my tips
pages informed me that he was not able to get my repeating data method (a
formfield input with REF fields to replicate) to work in his document.

It appears the problem is caused by a TOC in the document.  Fields (e,g.,
REF and formula are two that I tested with) that are located following the
TOC do not update properly with formfield set to "calculate on exit."

This is really easy to confirm for yourself.

Enter a {REF Text1} field

Enter a few lines of Heading 1 Text

Insert a TOC

Insert a couple of formfields and set Text1 to update on exit.

Enter another {REF Text1} field

Protect the document and see the result.  The REF field preceding the TOC
will update the one following won't.  The same results are observed with a
{=(x+y)} field.

Does anyone have an explanation or reference to a KB article?

Thanks.

Signature

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

Graham Mayor - 15 Sep 2005 06:00 GMT
You are right that it works (or rather doesn't work) as you say, but I
cannot put a finger on why. A workaround is to run an update macro on exit
from the field.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hello all,
>
[quoted text clipped - 26 lines]
>
> Thanks.
Greg - 16 Sep 2005 14:57 GMT
The answer provided via a different route by Bill Coan is to lock the
TOC.  As a TOC won't update anyway in a protected form it might as well
be locked.

Lock the TOC with CTRL+F11 before protecting the .doc
 
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.