Hi, does anyone know how I can show a text value for my option group selection on a form?

I have Satisifed = 1, Partial Satisified = 2, and Not Satisifed = 3. Data from option group is stored in a field "Status" When run my report based on the query it shows the number versus what it is?

Thanks!

In the text box that shows on the report, you can use this:

=IIf([Status]=1,"Satisfied',IIF([Status]=2,"Partial Satisfied',"Not Satisfied"))

Thanks Worked Perfect as shown.

=IIf([Status]=1,"Not Satisfied",IIf([Status]=2,"Partially Satisfied",IIf([Status]=3," Satisfied")))

You can also use:
=Choose([Status],"Satisfied',"Partial Satisfied',"Not Satisfied")

You can also use:
=Choose([Status],"Satisfied',"Partial Satisfied',"Not Satisfied")


Ooh, another thing to learn and it is much shorter! I like it! Thanks Allan!

I'm having a similar problem with a report. I want a 0 to give me "N" and a 1 to give me "Y". I've tried using IIf and Choose but the result is always "#Error".

I'm having a similar problem with a report. I want a 0 to give me "N" and a 1 to give me "Y". I've tried using IIf and Choose but the result is always "#Error".

What code, exactly, are you using? What are the names of your field and text box?

Whoops! I found the problem. I never changed the names of the controls so my control names were the same as my field names. Everything works fine now.

Whoops! I found the problem. I never changed the names of the controls so my control names were the same as my field names. Everything works fine now.

Yep, that would do it :D - Been there, done that before myself.