CheckBox groups

[Patrick C. Simonds]

On my form I have 42 question, each with 3 possible answers. So I have 42
groups of 3 CheckBoxes, is there anyway (short of writing code for each
CheckBox) to make it so that only 1 of the 3 CheckBoxes can be true at any
time?

I know that I could use OptionButtons to do this, but that the "power to be"
wants CheckBoxes, since the form can also be printed for manual fill in, and
he prefers CheckBoxes.

 

[Jay Freedman]

On my form I have 42 question, each with 3 possible answers. So I have 42
groups of 3 CheckBoxes, is there anyway (short of writing code for each
CheckBox) to make it so that only 1 of the 3 CheckBoxes can be true at any
time?

I know that I could use OptionButtons to do this, but that the "power to be"
wants CheckBoxes, since the form can also be printed for manual fill in, and
he prefers CheckBoxes.

See http://www.word.mvps.org/FAQs/TblsFldsFms/ExclusiveFmFldChbxs.htm

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.