Option groups in a report

[GSchafer1]

I have several 10 button option groups to displaly on my report. I would like to make the non selected buttons invisible. Any ideas???Thanks!

 

[Travis]

For each option group you will need to make a single Text field using a Choose statement. (Assuming values are 1 to 10)

Example:

Text box's control source =

=Choose([OptionGroup1],"Option 1", "Option 2","Option 3", "Option 4", "Option 5","Option 6", "Option 7","Option 8", "Option 9", "Option 10")

If you don't use 1 to 10 but 0 to 9 just do this

=Choose([OptionGroup1] + 1,"Option 1", "Option 2","Option 3", "Option 4", "Option 5","Option 6", "Option 7","Option 8", "Option 9", "Option 10")


Choose is good for sequential counts from 1 to what ever.