Displaying a label in reports from toggle buttons

[Princessboko]

I hope I can explain this properly. I have a very simple data entry form that has an Option Group with toggle buttons the user can select from.

Now when I create a report the report shows the value of the option box (1, 2, 3, etc.) Is there any way I can get the toggle button label to show on the report instead? I'm not sure how to do this.

Suggestions?

 

[Princessboko]

Figured it out (it is amazing how another cup of espresso can help you think)

Made another table with all the labels and made the values the autonumber. Made a relationship to the field from the new table. Made a query that just displays the description and put the query description in the report and it works.

 

[drjekyll325]

Do you mean you'd like to display the text that is next to the selected button on your form?

If so, you could use some nested IIF statement sin your control source. I'm assuming that you don't plan on changing the label text on the form, as you will be hard-coding that text into the IIF statement. The control source for your text box on the report will look something like this:

=iif([button_value] = 0, "Apple", iif([button_value] = 1, "Banana", iif([button_value] = 2, "Orange", "Other")))

Hope this helps!

 

[drjekyll325]

Looks like we cross-posted...

Great job finding a solution!