Deselect event?

[Steve C]

I am trying to program a Word 2003 document where a user rates employee
performance as either Competent, Developing or At-Risk (I'm using Check Box
form fields). The goal is that if At-Risk is chosen, it will take the user
to a comments text field immediately below these check boxes and not allow
the user to continue filling out the rest of the form until a comment has
been entered.

I can make this work when the user exits the At-Risk field by tabbing (using
the On Exit event of the Check Box field), but if a user clicks with his
mouse in a different area of the form, I need the same result to occur. Any
ideas on how I might accomplish that? Thanks!

 

[Graham Mayor]

You should be able to adapt the validation code at
http://www.gmayor.com/formfieldmacros.htm to suit your purposes. The
original code was designed to ensure that no fields were left empty, but you
can modify it to ensure that the comment field is not left empty when the
check box result indicates At Risk. You may find
http://word.mvps.org/faqs/tblsfldsfms/ExclusiveFmFldChbxs.htm useful also
(or you could use a dropdown field for your ability selection).

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Steve C]

Graham,

Thanks for the great reference! I will take a look and see if I can adapt
it for my purposes.