Hi Mo,
Check boxes can be forced to act that way, the option group control wizard
will help you create them that way from scratch.
Or you can put option groups on the form and transfer the existing check box
pairs into the group. One option group must be created for each pair and you
can't just drag them in, you must cut them from the form and paste them into
the option group. You then give each check box in the group a different
value (on the data tab of the properties box}.
Or you can manually attach event code to each check box that will turn off
its partner. That's tedious and generally useful only if you need other,
very specific things to happen, like some check boxes turn off all others in
the group and some do not.
But aside from all that, check boxes are not really intended to act that
way. They are supposed to be used for individual options that can be turned
on or off independent of each other, and the standards for graphic
interfaces have educated users to expect controls with a certain look to act
in a certain way. Going against this standard is rarely a good idea, unless
you like confused users.
What you want are radio buttons, or maybe toggle buttons. (Even a single
toggle button can be used to turn an option on or off. Some people don't
like them, but I've occasionally found them quite useful.) I would recommend
that you change your check boxes to radio buttons using the Format / Change
To / Radio Button menu, then proceed. All the above instructions apply to
radio buttons as well.
--
Pete
This e-mail address is fake to keep spammers and their auto-harvesters out
of my hair. If you need to get in touch personally, I am 'pdanes' and I use
Yahoo mail. But please use the newsgroups whenever possible, so that all may
benefit from the exchange of ideas.
