From Check Buttons

[JustaMessinOffice]

I am creating a form with check buttons.
There is a row of answers 1 to 5
I have options to check 5 buttons in a row.
I need to be able to specify how only one button can be checked in this row
of 5.
If I ma making sense please help.

J

 

[SMOO]

Check out this site, I think it has what you're looking for:
http://word.mvps.org/FAQs/TblsFldsFms/ExclusiveFmFldChbxs.htm

SMOO

 

[Josh]

I use Option buttons in the control toolbox. Create option buttons on
the form and go into the properties each option button and name the
group of buttons (ex: "Row1"). So in the properties GroupName would
be "Row1" and the Triplestate would be False. TripleState only allows
one button from the group to be selected. Exit design mode and your
button should work.

-Josh

 

[Josh]

Another option I like to use is the Option buttons in the Control
Toolbox Toolbar. They seem to work a little faster than check boxes
with code behind them. In the properties of the buttons you can
assign them group names so when one is selected the others will not
be.