Option Groups

[cheiboy]

In one of my forms, there are several option groups that I want to base reports off of. When I run the reports, it gives me a numeric value instead of the acutal text of what I want it to show. For example:
1 Authorized
2 Denied
3 Pending
4 STAT

I want the second column to show in the report instead of the numeric value. Any ideas anyone?

 

[jiqjaq]

Option Groups always store as a numeric value. Use a Select Case in the form before you call the report.

SELECT CASE <optiongroup>
CASE 1
strOption = &quot;Authorized&quot;
CASE 2
strOption = &quot;Denied&quot;
CASE 3
strOption = &quot;Pending&quot;
CASE 4
strOption = &quot;STAT&quot;
END SELECT

Store the value of strOption in a non-visible field on the form. Then reference that hidden field instead of the optiongroup on the report.

 

[dhookom]

I would suggest creating a table with these values. You can then either join the table into your report's recordsource or use a combo box with the lookup table as the row source.

Duane
MS Access MVP