Easy option button question

[Guest]

I'm making a simple form to populate a table. I'd like the grouped option
buttons to write a text value to the table field.

For example, I've got a color choice of red, white, or blue. I've got a set
of grouped option buttons that allow the user to select only one. It
populates the table with 1,2, or 3. How do I get it to populate the field
with "red", "white" or "blue"?

 

[Rick Brandt]

I'm making a simple form to populate a table. I'd like the grouped
option buttons to write a text value to the table field.

For example, I've got a color choice of red, white, or blue. I've
got a set of grouped option buttons that allow the user to select
only one. It populates the table with 1,2, or 3. How do I get it to
populate the field with "red", "white" or "blue"?

It would be better to NOT. You can easily use an expression...

=Choose([FieldName], "red", "white", "blue")

....to display the text on reports or in queries. If you insist on saving the
actual text strings then an Option Group is not the best choice of controls.
Switch to a ListBox or ComboBox.

 

[David F Cox]

or three buttons in the appropriate colours?

I'm making a simple form to populate a table. I'd like the grouped
option buttons to write a text value to the table field.

For example, I've got a color choice of red, white, or blue. I've
got a set of grouped option buttons that allow the user to select
only one. It populates the table with 1,2, or 3. How do I get it to
populate the field with "red", "white" or "blue"?

It would be better to NOT. You can easily use an expression...

=Choose([FieldName], "red", "white", "blue")

...to display the text on reports or in queries. If you insist on saving
the actual text strings then an Option Group is not the best choice of
controls. Switch to a ListBox or ComboBox.