Access Option (Radio) Buttons

  • Thread starter Thread starter Phillip Lanahan
  • Start date Start date
P

Phillip Lanahan

I am using radion buttons on a form and only get 1,2,3
values in the table to store the data. I think this is
the only option although I am not sure why..it is not
intuitive for me that it would be designed this way unless
they only like drop-boxes with micrsoft. If I can have
other values in the table besides numbers when a selection
with a button is made will someone let me know. Thanks
 
I'm going to say "No." From the help file:

Each control in an option group has a numeric value that you can set with
the OptionValue property. Read/write Long.
 
I am using radion buttons on a form and only get 1,2,3
values in the table to store the data. I think this is
the only option although I am not sure why..it is not
intuitive for me that it would be designed this way unless
they only like drop-boxes with micrsoft. If I can have
other values in the table besides numbers when a selection
with a button is made will someone let me know. Thanks
Click to expand...

An OptionGroup can only store a number value in the table.
However, you can then take that value and manipulate it in a form,
query, or report to display a text value.

Here is an example of converting a number value to text.
Assume an Option Group with 3 buttons.
The table stores 1, 2, or 3.
In a Report, using an unbound control:
=Choose([OptionGroupFieldName],"GradeA","GradeB","GradeC")

The report will show the text in place of the number value.
 
Back
Top