Ticking only one check box in a record

M

Marian

I have 5 check boxes in a record and I want to be able to limit input of data so that only one check box can be ticked. It's probably really straight forward, but can't find out through the usual help menus. Is it a validation rule expression, maybe?
Would really appreciate help.
Thanks ...
 
D

Duane Hookom

This sounds like an issue with your table structure. If I had 5 yes/no
fields that should only allow one selection, I would use a single field. My
forms would use an Option Group to select the one value. Is it possible for
you to change your table structure?

Otherwise, I suppose you could write a function in your data entry form that
would check the current control (check box) to see if it is True/Checked. If
it is, then set the other check boxes to false.

--
Duane Hookom
MS Access MVP
--

Marian said:
I have 5 check boxes in a record and I want to be able to limit input of
Click to expand...
data so that only one check box can be ticked. It's probably really
straight forward, but can't find out through the usual help menus. Is it a
validation rule expression, maybe?
 

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

Access 2013: Form problem in reading data tables; relationship one-to-one 0
One Check box or Two 2
Tick items in the subform instead of selection one by one by combo 5
Using check boxes to select criteria to run query 3
How do I complete a form by entering a tick in a check box? 2
Permissions for a check box? 1
Multiple Criteria in One Field 8
Check and clear Multiple check boxes 4

Top