Form Fields in Word Document

[spruceni]

Hi

I have created a word document which contains a number of form fields. This is retained as a locked template and the staff use it to generate new records when they contact a customer. The fields have dropdown lists which restricts the format of the input. There are other form fields which can contain free text.

We have found that it is not possible to use the spell checker when the form is locked. If you remove the locked state the form changes its layout considerably and is not suitable for the staff to use. Is there a work around to this?

 

[fumei]

1. "If you remove the locked state the form changes its layout considerably"

Use code to unlock, and then you can use NoReset:=True. that should probably retain things for you.

2. It is not possible to spellcheck when protected for forms. Have you tried to google this? This is an old and common issue.

Gerry

 

[spruceni]

Thanks for the reply. Being a complete novice at this could you outline how I lock and unlock the document using code. I tried recording a macro to do this but I did not get past the macro declaration. It seemed to stop once I pressed the unlock button.

If successful, would my users then have to run a macro to perform the spellcheck?

Regards

Alan

 

[fumei]

If successful, would my users then have to run a macro to perform the spellcheck?"

Yes.

You could put a button on a toolbar. Your user could click the button to execute the spellcheck. Although I would be more inclined to put it up on a toolbar as text. Something like:

"SpellCheck Form"

OR...depending on things, you could have it execute on saving the document.

Regarding the code...

Have you tried to google this? This is an old and common issue.

Gerry