How to check a check box?

G

George Yachán

I am trying to construct a Word doc which can be emailed, filled in and
returned (Would that be an online form?) with some text boxes and some
yes/no check boxes. The text boxes work fine and while I have no trouble
adding the check boxes to the form but I can't figure out how User is
supposed to select them.

The only way I can place an X in one is to double click it in order to open
the "Check Box Form Field Options" dialog box and then select the
appropriate Default value. Surely this is not the normal way to check the
box, but then please tell me how else to do it?
 
S

Suzanne S. Barnhill

When the document is protected, the box may be checked by clicking with the
mouse or by tabbing to it and pressing the spacebar.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
G

George Yachán

Well the form works great, but now I have a new challange. I would like to
send my Word doc out to 50 users as an email attachement and ask them to
fill it in. When the users reply, I can see that I am going to end up with
multiple copies of my original doc, all with the same file name but each
containing separate data. How do I handle the replys without opening each on
and manually cutting and pasting the responses? Is there a good way to
automatically get those data into something like an Excel workbook?
 
S

Suzanne S. Barnhill

Send it as a template (.dot file), which will require each user to create a
new document based on the template. In the covering email, provide
guidelines for file naming. That will take care of the names.

There is then a "Save data only for forms" option on the Save tab of Tools |
Options. I'm not sure exactly what format this creates--comma-separated
values, though, I think. In any case, you could then use Insert | File or
Graham Mayor's Boiler.dot add-in (see http://www.gmayor.com/downloads.htm)
to concatenate the files.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
G

George Yachán

Amazing! Thank you!

Last question: Getting all Users to change that setting might be asking a
lot for many of them. Can I write something in VBA which will set the "Save
Data only for froms" flag when the doc was opened or would any code like
that be likely to run into security/permission problems?
 
S

Suzanne S. Barnhill

Don't ask the users to do it (although it's a per-document setting and won't
cause problems with any of their other files). Let them send you the entire
form, and you can then set the flag and resave it (under another,
standardized filename if desired). And no, any kind of macro in the
document/template will just make it less likely that users will be able to
fill out the form properly.

I would suggest that you experiment with this thoroughly (fill out a form,
save data only, and examine what the results are and what you can do with
them) before adopting this course.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
G

George Yachán

Changing the setting on my end makes good sense but I will take your
suggestion and do some experimenting before sending anything off to the
users.

Thank you very much. Don't know how you can dedicate so much time to helping
others but I'm a satisfied customer!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top