Reset Form Fields


How to change the behaviour of Word's document protection, so users’ formfields don't get reset when they unprotect and reprotect


One of the biggest source of complaints from users about Word's forms protection feature (accessed from Tools + Protect or Unprotect document) is that when you unprotect and reprotect a form, all the form fields are reset and the data is lost.


This is a double-bind because of the fact that so many Word features are pointlessly disabled, even when only a part of a document is protected for forms. For more details, see: How to enable the spellchecker in a protected document. Because of the second problem, users frequently do want to unprotect and reprotect documents, which leaves them with the form fields resetting problem.


Note that in Word 2002 (Office XP), the problem does not arise if you reprotect the document using the "Protect Form" button of the Forms toolbar:


The form fields only get reset in Word 2002 if you use the menu. But in Word 97 and 2000, the form fields are reset whichever you use.


You can fix this by intercepting the built-in ToolsProtectUnprotectDocument and ProtectForm commands. Just paste the following code into an Addin. (Or you can paste it into a template, but if you use an addin, the problem will be fixed regardless of which template is in use.) Remove the horizontal line separating the two Subs, below, after pasting the code in. If your Addin is only for Word 2002, you won't require the ProtectForm macro, but will still require the ToolsProtectUnprotectDocument one.


Sub ToolsProtectUnprotectDocument() 

Dim oDoc As Document
Set oDoc = ActiveDocument

On Error GoTo ErrMess
If oDoc.ProtectionType = wdNoProtection Then
    With Dialogs(wdDialogToolsProtectDocument)
        .noreset = True
        .Show
    End With
Else
    oDoc.Unprotect
End If
Exit Sub

ErrMess:
    MsgBox Err.Description, vbInformation
End Sub

Sub ProtectForm() 
    If ActiveDocument.ProtectionType = wdAllowOnlyFormFields Then
        ActiveDocument.Unprotect
    Else
        ActiveDocument.Protect Type:=wdAllowOnlyFormFields, noreset:=True
    End If
End Sub

Note: If you do occasionally want the formfields to reset, you can just select Edit + Select All (or press Ctrl+A), while the document is unprotected, and press F9 (Update Fields).


Or in Word 2002, there is an additional button on the Forms toolbar to reset the form fields (while protection is switched off), without updating any other fields - an eraser. You could, if you wanted to, create a similar button for Word 97/2000 and assign it to the following macro:


Sub ResetFmFlds() 
    Dim FmFld As FormField
    If ActiveDocument.ProtectionType = wdNoProtection Then
        For Each FmFld In ActiveDocument.FormFields
            FmFld.Range.Fields(1).Update
        Next FmFld
    End If
End Sub

Also note that if the user updates the fields (by Selecting All and pressing F9) in an unprotected document then the form fields will get reset; this is by design. And therefore the form fields will also get reset if the user prints an unprotected document, and if "Update fields" is checked under Tools + Options + Print.


This behaviour is by design on the basis that only a forms designer ought to be updating the fields of, or printing, an unprotected document containing form fields; and for a forms designer, the ability to reset the form fields by updating them is sometimes very useful.


However, if you wanted to change this behaviour, you could either intercept the UpdateFields command or the FilePrint and FilePrintDefault commands.



© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrev