Binding a option button to a field???

[Guest]

Hi all,
Can anyone tell me how to bind a option button to a field in a table?
thanks

 

[Allen Browne]

If the option button is part of an option group, you can bind the option
group to a Number field in your table. For an example, open the Northwind
sample database that installs with Access, and see how the Ship Via option
group works on the Orders form. (They use check boxes, but option buttons
work the same.)

If the option button is not part of a group, you can bind it to a yes/no
field in the table. It toggles between two states: chosen and not chosen.

Whatever you do, don't create a heap of option buttons each bound to yes/no
fields. Explanation in this article:
Don't use Yes/No fields to store preferences
at:
http://allenbrowne.com/casu-23.html

 

[Arvin Meyer [MVP]]

Hi all,
Can anyone tell me how to bind a option button to a field in a table?
thanks

The easiest way to bind fields to controls is to use the Field Selector
(from the view menu) and drag the field to the form. The default control for
that datatype is chosen. You can also, first choose a control, then select a
field and drag it to the form.

An Option button can only be directly bound to a Boolean (yes/no) field. To
do so, add the field to the form and you'll most likely get a check box
control, right-click and choose Change To, then from the menu choose Option
Button.

If you have multiple values with a series of Option Buttons in a Frame,
click on the Option Group itself to select the frame and set the Data's
ControlSource value to the field.