spellchecking protected forms (2002)

Topic

New Reply

(Edited by HansV to provide link to post – see Help 19)

I have read all of the posts that talk about spellchecking in protected forms. I am trying to do that very thing. We have many forms that we use that are protected with form fields that the users tab from field to field to fill in. anyone can do it. We wanted to make it as easy as possible for them. However, you can’t spellcheck once it’s protected. Our users type quite a bit of information into these forms. Some of these grow to be 2-3 pages long. No longer a form in my opinion, but you can’t tell them that.

Anyway, I tried the formspeller but that only checks the part of the document that is not in fields. I need to check the fields for errors. I have been working with the VB code that I got off of the threads through the original post 432175. I cannot get it to check the form fields. When I use the example form that they give you, it works fine. However, when I copy the VB code to my form, it does not work. What am I missing? Can’t you copy VB code from one file to another?

I not a programmer. I don’t know a lot about VB, but I can fake it pretty good. I can’t figure out why it won’t work. Any help would be appreciated.

djbooks

Reply | Quote

Replies

Yes, you can copy VBA code from one document or template to another. But by default, form fields are set to be skipped when checking spelling and grammar. Try the following:

Unprotect your document.
Select the entire document.
Select Tools | Language | Set Language…
Click the “Do not check spelling and grammar” check box a few times until it is clear.
Click OK.
Reprotect your document for forms.

Enter some text in the form fields, including some errors, then try the macro again.

Reply | Quote

Hi Hans,

I tried that. It did not work. I am attaching both documents for you to look at. Like I said, I don’t see anything different in them as far as the code goes. If you look at the working document, the spellcheck is available as soon as you open the form. You don’t even have to run the macro. The not working document cannot be spellchecked unless you unlock the form which we are trying to avoid because they always forget to lock it again and the print and lose everything. What a nightmare!

Thanks again for your help

djbooks

Reply | Quote

There is some confusion here, I think. The “working document” has not been protected, so you can use the standard spell-checking menu option and toolbar button. However, nothing prevents the user from messing with the document, since it is not protected.

The second document is protected, and the macro works, but you haven’t provided a way to run it. I have attached a modified version (zipped) with a custom toolbar that lets the user check the spelling.

Reply | Quote

that works great! thanks so much for your help. You’re the best!

djbooks

Reply | Quote

that works great! thanks so much for your help. You’re the best!

djbooks

Reply | Quote

Hi Hans

Sorry to bother you again with this, but I am now trying to copy that code to my other forms and it does not work. If I go through the organizer and try and copy the toolbar, the copy button is grayed out (although it will let me copy it to another document but not a template). If I try to copy the VB code, it copies but when the spellcheck runs, it skips the form fields. What am I doing wrong?

djbooks

Reply | Quote

You must unprotect the document before trying to copy toolbars etc. If I do that, I don’t have problems copying the toolbar to either another document or to a template. You did select (click on) the SpellCheck toolbar in the Organizer, didn’t you? If you haven’t selected it, the Copy button will remain disabled.

And have you cleared the “Do not check spelling or grammar” check box for the entire document/template, as suggested in an earlier reply?

Reply | Quote

You must unprotect the document before trying to copy toolbars etc. If I do that, I don’t have problems copying the toolbar to either another document or to a template. You did select (click on) the SpellCheck toolbar in the Organizer, didn’t you? If you haven’t selected it, the Copy button will remain disabled.

And have you cleared the “Do not check spelling or grammar” check box for the entire document/template, as suggested in an earlier reply?

Reply | Quote

Hi Hans

Sorry to bother you again with this, but I am now trying to copy that code to my other forms and it does not work. If I go through the organizer and try and copy the toolbar, the copy button is grayed out (although it will let me copy it to another document but not a template). If I try to copy the VB code, it copies but when the spellcheck runs, it skips the form fields. What am I doing wrong?

djbooks

Reply | Quote

There is some confusion here, I think. The “working document” has not been protected, so you can use the standard spell-checking menu option and toolbar button. However, nothing prevents the user from messing with the document, since it is not protected.

The second document is protected, and the macro works, but you haven’t provided a way to run it. I have attached a modified version (zipped) with a custom toolbar that lets the user check the spelling.

Reply | Quote

Hi Hans,

I tried that. It did not work. I am attaching both documents for you to look at. Like I said, I don’t see anything different in them as far as the code goes. If you look at the working document, the spellcheck is available as soon as you open the form. You don’t even have to run the macro. The not working document cannot be spellchecked unless you unlock the form which we are trying to avoid because they always forget to lock it again and the print and lose everything. What a nightmare!

Thanks again for your help

djbooks

Reply | Quote

it would only let me attach one so here is the second one.

Reply | Quote

it would only let me attach one so here is the second one.

Reply | Quote

Yes, you can copy VBA code from one document or template to another. But by default, form fields are set to be skipped when checking spelling and grammar. Try the following:

Unprotect your document.
Select the entire document.
Select Tools | Language | Set Language…
Click the “Do not check spelling and grammar” check box a few times until it is clear.
Click OK.
Reprotect your document for forms.

Enter some text in the form fields, including some errors, then try the macro again.

Reply | Quote