Spell Checks for Multiple Subforms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that has 3 tabs. Each tab contains one subform. I would like
to let user to just click on ONE button to spellcheck both the main form and
the 3 subforms. How could that be done? J I have read some s about using
setfocus but I wasn’t succeed (and I have controls that are disenbled in the
form too).

Thanks *100000 J
 
I have a form that has 3 tabs. Each tab contains one subform. I would like
to let user to just click on ONE button to spellcheck both the main form and
the 3 subforms. How could that be done? J I have read some s about using
setfocus but I wasn’t succeed (and I have controls that are disenbled in the
form too).

Thanks *100000 J
Click to expand...

Given that a Subform will typically be bound to a "many" side table,
there might be any number of records in each subform's associated
table. You can't really spellcheck *a form* - you can spellcheck a
table text field; normally the best time to do so is when the field
has just been filled.

Could you explain the Recordsources of these four forms, and why it's
necessary to spellcheck *the subform*?

John W. Vinson[MVP]
 
Thanks for replying.

The reason I want to spell check all four forms (including the subform) is
because of a one-to-many relationship between a participant and # of
question. And, since questions are categorized into different sections, I
separate them into different subforms and tabs.

Basically, all the subforms correspond to the same table (well, the same
tableS or query).

Is there any ways that I can spell check all the forms (including the main
form) by pressing one single button? :) thanks *10000
 
Is there any ways that I can spell check all the forms (including the main
form) by pressing one single button? :) thanks *10000
Click to expand...

Again:

You cannot spell check a form.

A Form is just a window. You can't spell check the form any more than
I can hike the Owyhee Mountains by climbing up onto my windowledge.

I have REAL concerns about your database design here - four forms
bound to the same table is most unusual indeed. And if your form is
bound to a questionnaire table - wouldn't you have stored questions,
already spellchecked when they were entered? Do you want to let the
users spellcheck their answers? If so, why not do so field by field,
at the time they enter the text?

John W. Vinson[MVP]
 
well! The person entering the data into the database is on the phone, so
there is no time for him/her to edit it as he/she goes. The reason there are
3 forms basing on the same table is because the person talking on the phone
wants to be able to know what section he/she is in. I mean... I can have a
spell check button for every form (sub form), but I am just thinking that ONE
spell check button that could check all the forms would be the best.
 
Back
Top