Option button in Access tables

[Guest]

How do I insert checkboxes for different options (not merely a "Yes/No"
checkbox) in an Access table? I know it's possible in a form, but do the
tables have the same capability?

 

[Douglas J. Steele]

An option group produces a numeric value, not the text that's associated
with the selected button. That means that you could use a numeric field in
your table, and bind it to an option group, although it's probably not a
great idea: you could bind it on one form to "Blue", "Red", "Green", and
bind the same field to a different option group "Apple", "Orange",
"Pineapple" on a different form.