Converting Option Group values to text in a report

[dshort]

I have an option group on a form that allows the user to select the status of
a project (either Active, Closed or Canceled). The department manager wants
a report created that will show all of the projects and their current status.
How can I show the status on the report as a piece of text ("Active")
instead of as a number (1).

 

[jahoobob via AccessMonster.com]

Create a table with Active, Closed, and Cancelled in one field and 1,2,3 in
another field. In a query on which the report is based, add the new table
and link it to your main table via the 1,2,3 field and place the field with
Active, etc. in the query.

 

[fredg]

I have an option group on a form that allows the user to select the status of
a project (either Active, Closed or Canceled). The department manager wants
a report created that will show all of the projects and their current status.
How can I show the status on the report as a piece of text ("Active")
instead of as a number (1).

Here are 2 methods. There are more.
Use an unbound control.
Set it's controls source to:
=IIf([OptionGroupName]=1,"Active",IIf([OptionGroupName]=2,"Closed","Cancelled"))
Or..
=Choose([OptionGroupName],"Active","Closed","Cancelled")