Updating Fillable Word Document without clearing form field conten

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

akkrug - 26 Feb 2007 19:13 GMT

One of our users wants to be able to modify a fillable Word form but keep the
contents of the existing form fields intact. They have a questionnaire that
they want to add new questions to, but they don't want to wipe out the
answers to the existing questions that are saved in form fields on the form.
Any idea how we can do this? Would Mailmerge work for this situation or
possibly Access?

Thanks for the help.

Ken K. - 2191

Reply to this Message

Dawn Crosier, Word MVP - 26 Feb 2007 21:04 GMT

Have them display the Forms toolbar, and toggle the protection using the
padlock icon.

You could also program a macro button for them to use to toggle protection
on and off. This is the code that I use:

Sub proToggleFormLock()

'Toggle the Protection on and off

If ActiveDocument.ProtectionType = wdAllowOnlyFormFields Then

ActiveDocument.Unprotect Password:="mypassword"

Else

ActiveDocument.Protect Password:="mypassword", NoReset:=True,
Type:= _

wdAllowOnlyFormFields

End If

End Sub

Signature

Dawn Crosier
Microsoft MVP
"Education Lasts a Lifetime"

This message was posted to a newsgroup, Please post replies and questions
to the group so that others can learn as well.

One of our users wants to be able to modify a fillable Word form but keep
the
contents of the existing form fields intact. They have a questionnaire that
they want to add new questions to, but they don't want to wipe out the
answers to the existing questions that are saved in form fields on the form.
Any idea how we can do this? Would Mailmerge work for this situation or
possibly Access?

Thanks for the help.

Ken K. - 2191

Reply to this Message

akkrug - 27 Feb 2007 13:22 GMT

Dawn,

Thanks so much. Your macro works very well!!

Ken K. - 2191

Signature

akkrug

> Have them display the Forms toolbar, and toggle the protection using the
> padlock icon.
[quoted text clipped - 32 lines]
>
> Ken K. - 2191

Reply to this Message

Dawn Crosier, Word MVP - 28 Feb 2007 02:34 GMT

Good to hear!

Signature

Dawn Crosier
Microsoft MVP
"Education Lasts a Lifetime"

This message was posted to a newsgroup, Please post replies and questions
to the group so that others can learn as well.

Dawn,

Thanks so much. Your macro works very well!!

Ken K. - 2191

Signature

akkrug

"Dawn Crosier, Word MVP" wrote:

> Have them display the Forms toolbar, and toggle the protection using the
> padlock icon.
[quoted text clipped - 34 lines]
>
> Ken K. - 2191

Reply to this Message