Forms vs SpellCheck

Jack_Feeman · External Since: Jun 28, 2006 Posts: 22

I have read the cited collaborated instruction "How toenable the spellchecker
in a protected document and very much impressed with its thoroughness. This
question is based on the document being a form with form fields and text on
the same line so the division of protected/unprotected areas by continuous
page breaks is not the answer.

I tried to write a macro assigned to a button which when clicked would (1)
unprotect the document, (2) spellcheck the entire document, and (3)
re-protect the document. I finally got it to work but the spell checker
didn't seem to catch spelling errors in text boxes in the form, so I tried to
spellcheck it with the normal menu bar (F7) control. I found that while it
did work with text entered in the Text Form Field; it did not work with text
in Text boxes.

(1) I concluded that if all user entries have to be speel-checked; text form
fields have to be used in lieu of Text boxes. Is this Correct?
(2) Is my macro an easier way to spellcheck a Word Form in view of the
limitation sited in the first paragraph when using breaks to divide areas of
the form to protect/unprotect?

Thanks

Charles Kenyon · External Since: Apr 25, 2006 Posts: 1406

The macro on the MVP website is _the way_ to do a spell check of a protected
form. You should not use a text box in a form as a field holder. Convert the
text box to a frame and see if that helps.

--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Jack_Feeman" <JackFeeman DeleteThis @discussions.microsoft.com> wrote in message
news:98EDD89F-8B04-4081-9862-37A7B42223EB@microsoft.com...
>I have read the cited collaborated instruction "How toenable the
>spellchecker
> in a protected document and very much impressed with its thoroughness.
> This
> question is based on the document being a form with form fields and text
> on
> the same line so the division of protected/unprotected areas by continuous
> page breaks is not the answer.
>
> I tried to write a macro assigned to a button which when clicked would (1)
> unprotect the document, (2) spellcheck the entire document, and (3)
> re-protect the document. I finally got it to work but the spell checker
> didn't seem to catch spelling errors in text boxes in the form, so I tried
> to
> spellcheck it with the normal menu bar (F7) control. I found that while it
> did work with text entered in the Text Form Field; it did not work with
> text
> in Text boxes.
>
> (1) I concluded that if all user entries have to be speel-checked; text
> form
> fields have to be used in lieu of Text boxes. Is this Correct?
> (2) Is my macro an easier way to spellcheck a Word Form in view of the
> limitation sited in the first paragraph when using breaks to divide areas
> of
> the form to protect/unprotect?
>
> Thanks

Jack_Feeman · External Since: Jun 28, 2006 Posts: 22

Thanks Charles,

I will retry the MVP suggestion. Maybe I missed something about separating
half a line with section breaks. (The form has a text form field followed by
checkboxes on the same line. I wanted to place the check boxes in the
protected part but not the form fields.)

Thanks for the tip on text boxes vs form fields.

"Charles Kenyon" wrote:

> The macro on the MVP website is _the way_ to do a spell check of a protected
> form. You should not use a text box in a form as a field holder. Convert the
> text box to a frame and see if that helps.
>
>
> --
> Charles Kenyon
>
> Word New User FAQ & Web Directory: http://addbalance.com/word
>
> Intermediate User's Guide to Microsoft Word (supplemented version of
> Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
>
> See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
> --------- --------- --------- --------- --------- ---------
> This message is posted to a newsgroup. Please post replies
> and questions to the newsgroup so that others can learn
> from my ignorance and your wisdom.
>
>
> "Jack_Feeman" <JackFeeman.RemoveThis@discussions.microsoft.com> wrote in message
> news:98EDD89F-8B04-4081-9862-37A7B42223EB@microsoft.com...
> >I have read the cited collaborated instruction "How toenable the
> >spellchecker
> > in a protected document and very much impressed with its thoroughness.
> > This
> > question is based on the document being a form with form fields and text
> > on
> > the same line so the division of protected/unprotected areas by continuous
> > page breaks is not the answer.
> >
> > I tried to write a macro assigned to a button which when clicked would (1)
> > unprotect the document, (2) spellcheck the entire document, and (3)
> > re-protect the document. I finally got it to work but the spell checker
> > didn't seem to catch spelling errors in text boxes in the form, so I tried
> > to
> > spellcheck it with the normal menu bar (F7) control. I found that while it
> > did work with text entered in the Text Form Field; it did not work with
> > text
> > in Text boxes.
> >
> > (1) I concluded that if all user entries have to be speel-checked; text
> > form
> > fields have to be used in lieu of Text boxes. Is this Correct?
> > (2) Is my macro an easier way to spellcheck a Word Form in view of the
> > limitation sited in the first paragraph when using breaks to divide areas
> > of
> > the form to protect/unprotect?
> >
> > Thanks
>
>
>

Charles Kenyon · External Since: Apr 25, 2006 Posts: 1406

Text form fields should be in the protected part as well. That is what they
are there for.

No, you didn't miss anything as far as section breaks. You can't have half
of a line protected and the other half unprotected.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Jack_Feeman" <JackFeeman.RemoveThis@discussions.microsoft.com> wrote in message
news:B86E2410-7479-418A-9EC6-9F53F405844C@microsoft.com...
> Thanks Charles,
>
> I will retry the MVP suggestion. Maybe I missed something about separating
> half a line with section breaks. (The form has a text form field followed
> by
> checkboxes on the same line. I wanted to place the check boxes in the
> protected part but not the form fields.)
>
> Thanks for the tip on text boxes vs form fields.
>
> "Charles Kenyon" wrote:
>
>> The macro on the MVP website is _the way_ to do a spell check of a
>> protected
>> form. You should not use a text box in a form as a field holder. Convert
>> the
>> text box to a frame and see if that helps.
>>
>>
>> --
>> Charles Kenyon
>>
>> Word New User FAQ & Web Directory: http://addbalance.com/word
>>
>> Intermediate User's Guide to Microsoft Word (supplemented version of
>> Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
>>
>> See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
>> --------- --------- --------- --------- --------- ---------
>> This message is posted to a newsgroup. Please post replies
>> and questions to the newsgroup so that others can learn
>> from my ignorance and your wisdom.
>>
>>
>> "Jack_Feeman" <JackFeeman.RemoveThis@discussions.microsoft.com> wrote in message
>> news:98EDD89F-8B04-4081-9862-37A7B42223EB@microsoft.com...
>> >I have read the cited collaborated instruction "How toenable the
>> >spellchecker
>> > in a protected document and very much impressed with its thoroughness.
>> > This
>> > question is based on the document being a form with form fields and
>> > text
>> > on
>> > the same line so the division of protected/unprotected areas by
>> > continuous
>> > page breaks is not the answer.
>> >
>> > I tried to write a macro assigned to a button which when clicked would
>> > (1)
>> > unprotect the document, (2) spellcheck the entire document, and (3)
>> > re-protect the document. I finally got it to work but the spell checker
>> > didn't seem to catch spelling errors in text boxes in the form, so I
>> > tried
>> > to
>> > spellcheck it with the normal menu bar (F7) control. I found that while
>> > it
>> > did work with text entered in the Text Form Field; it did not work with
>> > text
>> > in Text boxes.
>> >
>> > (1) I concluded that if all user entries have to be speel-checked; text
>> > form
>> > fields have to be used in lieu of Text boxes. Is this Correct?
>> > (2) Is my macro an easier way to spellcheck a Word Form in view of the
>> > limitation sited in the first paragraph when using breaks to divide
>> > areas
>> > of
>> > the form to protect/unprotect?
>> >
>> > Thanks
>>
>>
>>

Jack_Feeman · External Since: Jun 28, 2006 Posts: 22

Thanks

"Charles Kenyon" wrote:

> Text form fields should be in the protected part as well. That is what they
> are there for.
>
> No, you didn't miss anything as far as section breaks. You can't have half
> of a line protected and the other half unprotected.
> --
> Charles Kenyon
>
> Word New User FAQ & Web Directory: http://addbalance.com/word
>
> Intermediate User's Guide to Microsoft Word (supplemented version of
> Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
>
> See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
> --------- --------- --------- --------- --------- ---------
> This message is posted to a newsgroup. Please post replies
> and questions to the newsgroup so that others can learn
> from my ignorance and your wisdom.
>
>
> "Jack_Feeman" <JackFeeman DeleteThis @discussions.microsoft.com> wrote in message
> news:B86E2410-7479-418A-9EC6-9F53F405844C@microsoft.com...
> > Thanks Charles,
> >
> > I will retry the MVP suggestion. Maybe I missed something about separating
> > half a line with section breaks. (The form has a text form field followed
> > by
> > checkboxes on the same line. I wanted to place the check boxes in the
> > protected part but not the form fields.)
> >
> > Thanks for the tip on text boxes vs form fields.
> >
> > "Charles Kenyon" wrote:
> >
> >> The macro on the MVP website is _the way_ to do a spell check of a
> >> protected
> >> form. You should not use a text box in a form as a field holder. Convert
> >> the
> >> text box to a frame and see if that helps.
> >>
> >>
> >> --
> >> Charles Kenyon
> >>
> >> Word New User FAQ & Web Directory: http://addbalance.com/word
> >>
> >> Intermediate User's Guide to Microsoft Word (supplemented version of
> >> Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
> >>
> >> See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
> >> --------- --------- --------- --------- --------- ---------
> >> This message is posted to a newsgroup. Please post replies
> >> and questions to the newsgroup so that others can learn
> >> from my ignorance and your wisdom.
> >>
> >>
> >> "Jack_Feeman" <JackFeeman DeleteThis @discussions.microsoft.com> wrote in message
> >> news:98EDD89F-8B04-4081-9862-37A7B42223EB@microsoft.com...
> >> >I have read the cited collaborated instruction "How toenable the
> >> >spellchecker
> >> > in a protected document and very much impressed with its thoroughness.
> >> > This
> >> > question is based on the document being a form with form fields and
> >> > text
> >> > on
> >> > the same line so the division of protected/unprotected areas by
> >> > continuous
> >> > page breaks is not the answer.
> >> >
> >> > I tried to write a macro assigned to a button which when clicked would
> >> > (1)
> >> > unprotect the document, (2) spellcheck the entire document, and (3)
> >> > re-protect the document. I finally got it to work but the spell checker
> >> > didn't seem to catch spelling errors in text boxes in the form, so I
> >> > tried
> >> > to
> >> > spellcheck it with the normal menu bar (F7) control. I found that while
> >> > it
> >> > did work with text entered in the Text Form Field; it did not work with
> >> > text
> >> > in Text boxes.
> >> >
> >> > (1) I concluded that if all user entries have to be speel-checked; text
> >> > form
> >> > fields have to be used in lieu of Text boxes. Is this Correct?
> >> > (2) Is my macro an easier way to spellcheck a Word Form in view of the
> >> > limitation sited in the first paragraph when using breaks to divide
> >> > areas
> >> > of
> >> > the form to protect/unprotect?
> >> >
> >> > Thanks
> >>
> >>
> >>
>
>
>

jrfloyd · External Since: Mar 30, 2006 Posts: 1

I have a form with text fields in it. The form is protected. I also have
bookmarks with matching referance fields. The bookmarks are set to calculate
upon exit. The problem is as soon as the user tabs through one of the fields
it sets the Language setting back to do not spell check for the whole
document. I have tried the macro on the MVP website and it does not work
because the text fields get set back to not spell check and it does not
change that. I can get it to spell check if I unprotect the form, highlight
the text, go to the language setting and uncheck the do not spell check. But
that has to be done on every text field I want to spell check on every time I
use the form. Can a macro be written or modified to do this for me? Or is
there a way to set the document to allow spell check even if it has bookmarks
that calculate on exit. I know its the bookmarks that are the problem because
the document keeps the language setting I give it and spell checks the text
fileds until I add the bookmark and tell it to calculate on exit. I'm at the
end of my rope on this so any help would be great.

"Charles Kenyon" wrote:

> Text form fields should be in the protected part as well. That is what they
> are there for.
>
> No, you didn't miss anything as far as section breaks. You can't have half
> of a line protected and the other half unprotected.
> --
> Charles Kenyon
>
> Word New User FAQ & Web Directory: http://addbalance.com/word
>
> Intermediate User's Guide to Microsoft Word (supplemented version of
> Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
>
> See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
> --------- --------- --------- --------- --------- ---------
> This message is posted to a newsgroup. Please post replies
> and questions to the newsgroup so that others can learn
> from my ignorance and your wisdom.
>
>
> "Jack_Feeman" <JackFeeman.DeleteThis@discussions.microsoft.com> wrote in message
> news:B86E2410-7479-418A-9EC6-9F53F405844C@microsoft.com...
> > Thanks Charles,
> >
> > I will retry the MVP suggestion. Maybe I missed something about separating
> > half a line with section breaks. (The form has a text form field followed
> > by
> > checkboxes on the same line. I wanted to place the check boxes in the
> > protected part but not the form fields.)
> >
> > Thanks for the tip on text boxes vs form fields.
> >
> > "Charles Kenyon" wrote:
> >
> >> The macro on the MVP website is _the way_ to do a spell check of a
> >> protected
> >> form. You should not use a text box in a form as a field holder. Convert
> >> the
> >> text box to a frame and see if that helps.
> >>
> >>
> >> --
> >> Charles Kenyon
> >>
> >> Word New User FAQ & Web Directory: http://addbalance.com/word
> >>
> >> Intermediate User's Guide to Microsoft Word (supplemented version of
> >> Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
> >>
> >> See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
> >> --------- --------- --------- --------- --------- ---------
> >> This message is posted to a newsgroup. Please post replies
> >> and questions to the newsgroup so that others can learn
> >> from my ignorance and your wisdom.
> >>
> >>
> >> "Jack_Feeman" <JackFeeman.DeleteThis@discussions.microsoft.com> wrote in message
> >> news:98EDD89F-8B04-4081-9862-37A7B42223EB@microsoft.com...
> >> >I have read the cited collaborated instruction "How toenable the
> >> >spellchecker
> >> > in a protected document and very much impressed with its thoroughness.
> >> > This
> >> > question is based on the document being a form with form fields and
> >> > text
> >> > on
> >> > the same line so the division of protected/unprotected areas by
> >> > continuous
> >> > page breaks is not the answer.
> >> >
> >> > I tried to write a macro assigned to a button which when clicked would
> >> > (1)
> >> > unprotect the document, (2) spellcheck the entire document, and (3)
> >> > re-protect the document. I finally got it to work but the spell checker
> >> > didn't seem to catch spelling errors in text boxes in the form, so I
> >> > tried
> >> > to
> >> > spellcheck it with the normal menu bar (F7) control. I found that while
> >> > it
> >> > did work with text entered in the Text Form Field; it did not work with
> >> > text
> >> > in Text boxes.
> >> >
> >> > (1) I concluded that if all user entries have to be speel-checked; text
> >> > form
> >> > fields have to be used in lieu of Text boxes. Is this Correct?
> >> > (2) Is my macro an easier way to spellcheck a Word Form in view of the
> >> > limitation sited in the first paragraph when using breaks to divide
> >> > areas
> >> > of
> >> > the form to protect/unprotect?
> >> >
> >> > Thanks
> >>
> >>
> >>
>
>
>

Charles Kenyon · External Since: Apr 25, 2006 Posts: 1406

Please start a new thread to get the best advice on this. The macro on the
MVP site works. It works with REF fields that are based on formfields. The
formfields can be set to calculate on exit. The macro still works.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"jrfloyd" <jrfloyd.RemoveThis@discussions.microsoft.com> wrote in message
news:553149D2-C421-47DA-9037-FB25E538F892@microsoft.com...
>I have a form with text fields in it. The form is protected. I also have
> bookmarks with matching referance fields. The bookmarks are set to
> calculate
> upon exit. The problem is as soon as the user tabs through one of the
> fields
> it sets the Language setting back to do not spell check for the whole
> document. I have tried the macro on the MVP website and it does not work
> because the text fields get set back to not spell check and it does not
> change that. I can get it to spell check if I unprotect the form,
> highlight
> the text, go to the language setting and uncheck the do not spell check.
> But
> that has to be done on every text field I want to spell check on every
> time I
> use the form. Can a macro be written or modified to do this for me? Or is
> there a way to set the document to allow spell check even if it has
> bookmarks
> that calculate on exit. I know its the bookmarks that are the problem
> because
> the document keeps the language setting I give it and spell checks the
> text
> fileds until I add the bookmark and tell it to calculate on exit. I'm at
> the
> end of my rope on this so any help would be great.
>
> "Charles Kenyon" wrote:
>
>> Text form fields should be in the protected part as well. That is what
>> they
>> are there for.
>>
>> No, you didn't miss anything as far as section breaks. You can't have
>> half
>> of a line protected and the other half unprotected.
>> --
>> Charles Kenyon
>>
>> Word New User FAQ & Web Directory: http://addbalance.com/word
>>
>> Intermediate User's Guide to Microsoft Word (supplemented version of
>> Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
>>
>> See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
>> --------- --------- --------- --------- --------- ---------
>> This message is posted to a newsgroup. Please post replies
>> and questions to the newsgroup so that others can learn
>> from my ignorance and your wisdom.
>>
>>
>> "Jack_Feeman" <JackFeeman.RemoveThis@discussions.microsoft.com> wrote in message
>> news:B86E2410-7479-418A-9EC6-9F53F405844C@microsoft.com...
>> > Thanks Charles,
>> >
>> > I will retry the MVP suggestion. Maybe I missed something about
>> > separating
>> > half a line with section breaks. (The form has a text form field
>> > followed
>> > by
>> > checkboxes on the same line. I wanted to place the check boxes in the
>> > protected part but not the form fields.)
>> >
>> > Thanks for the tip on text boxes vs form fields.
>> >
>> > "Charles Kenyon" wrote:
>> >
>> >> The macro on the MVP website is _the way_ to do a spell check of a
>> >> protected
>> >> form. You should not use a text box in a form as a field holder.
>> >> Convert
>> >> the
>> >> text box to a frame and see if that helps.
>> >>
>> >>
>> >> --
>> >> Charles Kenyon
>> >>
>> >> Word New User FAQ & Web Directory: http://addbalance.com/word
>> >>
>> >> Intermediate User's Guide to Microsoft Word (supplemented version of
>> >> Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
>> >>
>> >> See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
>> >> --------- --------- --------- --------- --------- ---------
>> >> This message is posted to a newsgroup. Please post replies
>> >> and questions to the newsgroup so that others can learn
>> >> from my ignorance and your wisdom.
>> >>
>> >>
>> >> "Jack_Feeman" <JackFeeman.RemoveThis@discussions.microsoft.com> wrote in message
>> >> news:98EDD89F-8B04-4081-9862-37A7B42223EB@microsoft.com...
>> >> >I have read the cited collaborated instruction "How toenable the
>> >> >spellchecker
>> >> > in a protected document and very much impressed with its
>> >> > thoroughness.
>> >> > This
>> >> > question is based on the document being a form with form fields and
>> >> > text
>> >> > on
>> >> > the same line so the division of protected/unprotected areas by
>> >> > continuous
>> >> > page breaks is not the answer.
>> >> >
>> >> > I tried to write a macro assigned to a button which when clicked
>> >> > would
>> >> > (1)
>> >> > unprotect the document, (2) spellcheck the entire document, and (3)
>> >> > re-protect the document. I finally got it to work but the spell
>> >> > checker
>> >> > didn't seem to catch spelling errors in text boxes in the form, so I
>> >> > tried
>> >> > to
>> >> > spellcheck it with the normal menu bar (F7) control. I found that
>> >> > while
>> >> > it
>> >> > did work with text entered in the Text Form Field; it did not work
>> >> > with
>> >> > text
>> >> > in Text boxes.
>> >> >
>> >> > (1) I concluded that if all user entries have to be speel-checked;
>> >> > text
>> >> > form
>> >> > fields have to be used in lieu of Text boxes. Is this Correct?
>> >> > (2) Is my macro an easier way to spellcheck a Word Form in view of
>> >> > the
>> >> > limitation sited in the first paragraph when using breaks to divide
>> >> > areas
>> >> > of
>> >> > the form to protect/unprotect?
>> >> >
>> >> > Thanks
>> >>
>> >>
>> >>
>>
>>
>>