Replacing text for a report

[Zaram]

In the database design, we have a fixed option group where they either choose one radio button or the other. These values are recorded in the database as either a 1 or 2 depending on which radio button is selected. When I create a report though, I need to have the status listed as Open or Closed (1 and 2 respectively) but havent figured out how to accomplish this task. Any help would be appreciated.

[pbaldy]

If those values are in another table, you'd base the report on a query that joined that table with the "main" data table, enabling you to return the text value. If not, an IIf() would be an option:

=IIf(FieldName = 1, "Open", "Closed")

[Zaram]

Thanks for the response. I was placing the code into the format line when I right click that area of the report in design view. It just now is blank instead when the report is run, is that code supposed to be entered in a different area?

I apologize for any ignorance, it has been a while since I worked in Access.

[pbaldy]

It would be the control source of a textbox.

[Zaram]

When I go to the design view of the report it does not allow the option to place a textbox into the report so I don't understand how I could put that code into a text box in the report. Addt'l clarification please?

[pbaldy]

Really? You don't have an MDE, do you? Can you post the db?

[Zaram]

Actually my apologies once more. I took another look at it all and was able to make a new text box just not alternate the text area that was reporting 1 or 2. I made the necessary changes and it is working well. Thanks again for the assistance and patience.

[pbaldy]

Ah good, glad we got it sorted out. Welcome to the site by the way!