Option Button Values as Text in a Report 1

[phishfn]

I have a form with a group of option buttons, one for "Hardware" and another for "Software". Of course the values that display for these buttons in a report are numeric, but I need them to show up as text on the report. I.e., The user selects the "Hardware" option, clicks a button to show a report, but the option selected shows up as 1 instead of "Hardware". I know this should be easy but I just can't get it to work. Any help would be dearly appreciated. Thanks.

 

[dhookom]

You can bind a control to:
=Choose(Forms!frmYourForm!optHardSoft,"1-Hardware","2-Software&quot
This makes assumptions based on your form and control names as well as the values of the option group.

Duane
MS Access MVP

 

[dhookom]

I should have also mentioned, if you have a field in your report that stores either 1 or 2, you can use:

=Choose([YourField],"Hardware","Software&quot

Duane
MS Access MVP

 

[phishfn]

Excellent! Thank you so much for your help. It works great!