Getting Spell Check to work in Text Form Fields

[Craig]

Hi,

I have a form that includes many text form fields in which people fill in
with a lot of text...how do I tell the users who fill in the form with text
to run the spell checker to check for spelling errors on what they typed
within those form fields?

Thank you

Craig

 

[Jean-Guy Marcil]

Hi,

I have a form that includes many text form fields in which people fill in
with a lot of text...how do I tell the users who fill in the form with text
to run the spell checker to check for spelling errors on what they typed
within those form fields?

See
http://word.mvps.org/faqs/macrosvba/SpellcheckProtectDoc.htm

 

[Craig]

Thank you.

the code works but only when the doc is unprotected...I want my users to
open the document protected, fill in all their required form fields, then
press a key like Alt S to get the macro to run the spell check of the form
fields.

How can I do this?

Thank you

Craig

 

[Jean-Guy Marcil]

Thank you.

the code works but only when the doc is unprotected...I want my users to
open the document protected, fill in all their required form fields, then
press a key like Alt S to get the macro to run the spell check of the form
fields.

Read the article again, maybe a bit slower tis time? ;-)

The code is designed to work with protected documents (Otherwise, if the
document is not protected, you do not need code at all...). If you get
something else as a result, you did something wrong... Not sure what... So go
back and make sure you did exactly as described in the article. Also, make
sure you copy paste the code correctly.

As a final thought, make sure you actually use the code to do the spell
check, not the built-in "Check Spelling" button on the Word toolbar.
If you want (and if you are working correctly with templates), you can
create a button and assign your macro to this button; then, copy the image
from the Word built-in button and paste it on your button. Now you can remove
the built-in one. To copy/paste a toolbar button, just right-click on the
button to access all the editing options for buttons after making sure you
are in customizing mode (Right-click any toolbar and select "Customize").

 

[Craig]

Sorry to bother you again, but I did exactly as in article.

I noticed that your document , Spell Check Sample, you can click Tool
Spelling and Grammar even when protected...but you can also alter text in the
unprotected section 2.

With my document, when I open it (template or not) Tools, Spelling and
Grammar is grayed out and not available, and I can not go anyway but the fill
in field...to run the code that you gave me I have to go into VBA code, and
press F5 to run it....but I dont want my users to do this...I want them to
press Tools, Spelling and Grammer, F7 key or something like Alt S

Can you tell what I am doing wrong?

Thank you very much

Craig

 

[Jean-Guy Marcil]

Sorry to bother you again, but I did exactly as in article.

I noticed that your document , Spell Check Sample, you can click Tool
Spelling and Grammar even when protected...but you can also alter text in the
unprotected section 2.

With my document, when I open it (template or not) Tools, Spelling and
Grammar is grayed out and not available, and I can not go anyway but the fill
in field...to run the code that you gave me I have to go into VBA code, and
press F5 to run it....but I dont want my users to do this...I want them to
press Tools, Spelling and Grammer, F7 key or something like Alt S

Can you tell what I am doing wrong?

As I wrote in my previous post:

"As a final thought, make sure you actually use the code to do the spell
check, not the built-in "Check Spelling" button on the Word toolbar.
If you want (and if you are working correctly with templates), you can
create a button and assign your macro to this button; then, copy the image
from the Word built-in button and paste it on your button. Now you can remove
the built-in one. To copy/paste a toolbar button, just right-click on the
button to access all the editing options for buttons after making sure you
are in customizing mode (Right-click any toolbar and select "Customize")."

To add a butoon to a toolbar: With your template open and unprotected,
right-click any toolbar and select "Customize", make sure you are in the
"Commands" tab. In the "Categories" area on the left, select "Macros" (Toward
the end). Then find your macro in the "Commands" area on the right. Drag and
drop your macro onto the toolbar, next to the built-in "Check Spelling"
button (The one that is greyed out once you potect your template).
Right click the built-in Spelling button and select "Copy Button Image",
then right click on your new button and select "Paste Button Image" and also
select "Default Style" so that only the image is visible. Finally, delete the
built-in button which will be useless anyway as it is greyed out...
Exit the Customizing mode, protect your template and save it.

Now the user will have a functional "Check Spelling" button and will not
know that you replaced the built-in one with your own (unless they are
familiar with macros...)

 

[Craig]

You have been extremely helpful and responsive, Jean-Guy...thank you!

With your solution, as I am distributing this form out to over 20 people
over a network, it seems like I have to do the procedure of creating a button
at each person's desktop...thats over 20 times...thats why I wanted a built
in macro shortcut key like Alt +S so the user once they get my form, can then
fill it in and press Alt S to get the code you gave me to run...I guess thats
not possible. Maybe I can come up with a workaround using your code.

Thanks again

 

[Jean-Guy Marcil]

You have been extremely helpful and responsive, Jean-Guy...thank you!

With your solution, as I am distributing this form out to over 20 people
over a network, it seems like I have to do the procedure of creating a button
at each person's desktop...thats over 20 times...thats why I wanted a built
in macro shortcut key like Alt +S so the user once they get my form, can then
fill it in and press Alt S to get the code you gave me to run...I guess thats
not possible. Maybe I can come up with a workaround using your code.

If you are using a template (*.dot) you only need to do it once in the
template you designed, as I wrote in some details in my previous post.
Once you distribute that, when users create documents (*.doc) from the
template, the modification on the toolbar will be available automatically.

Whether you use my suggetion or ALT-S (or any other keyboard shortcut), if
you do not use a template, whatever it is that you do, you will have to do 20
times (A macro you create is not, by definition, built-in. So there will not
be a "built-in" short cut at each user desk connected to the macro, you will
have to create that short cut).

Again, you should work with a template, not a document.

 

[Craig]

Ah, this is great...I will use a template...thanks so much!

Craig

 

[Craig]

Hi The spell check works but not grammar in the form field (I made a grammar
error and spell check error in two different form fields)

While it caught the spelling error and did not catch the grammar error, I
still got the message that the spelling and grammar check is complete.

Any thoughts? Thank you!

 

[Jean-Guy Marcil]

Hi The spell check works but not grammar in the form field (I made a grammar
error and spell check error in two different form fields)

While it caught the spelling error and did not catch the grammar error, I
still got the message that the spelling and grammar check is complete.

Any thoughts? Thank you!

The code I pointed you to is designed to handle spelling, not grammar.

I am not familiar with handling grammar checking with VBA.

I would suggest that you start a new thread for that, it might be easier to
attract other people's expertise...

But, that being said, I personally do not like the grammar checking... it
always picks up silly stuff (like passive voice, sentences with no verbs,
etc.).