How to populate Access Database Using Checkboxes?

Question

I am trying to populate one column in an Access table using two check boxes - one for 0, one for 10. How do I make it so that on click or after update, whichever check box is checked populates the cell with the associated number?

Any assistance (if there's a better way to choose from two values?) would be much appreciated.

Regards, Steve

Patrick Honorez · Accepted Answer · 2011-03-20 16:56:07Z

2

A check box does not seem to me appropriate for selecting between 0 and 10, since

you cannot bind it as such to field in your table
it is a control commonly associated with Yes/No values

I would rather go here with an Option group (if you have enough space) or with a combo box (drop down list).

You did not mention if the field is Required nor the type of field. If field is not Required (meaning it must handle Null value), go for the Combo.

answered Mar 20, 2011 at 16:56

Patrick Honorez

25.4k12 gold badges97 silver badges163 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

TheOtherTimDuncan · Accepted Answer · 2011-03-20 11:17:15Z

0

A toggle button is probably more what you're looking for. A drop down list would work as well.

answered Mar 20, 2011 at 11:17

TheOtherTimDuncan

6035 silver badges6 bronze badges

1 Comment

Patrick Honorez Over a year ago

Toggle is functionally equivalent to Checkbox, and not very suitable here, nor easy to implement IMHO, nor able to handle Nulls well.

Collectives™ on Stack Overflow

How to populate Access Database Using Checkboxes?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related