Option group to display on a report

[SylvieB]

On a form, I have created an option group by using a wizard. I have 3 label
names Yes/No/NA set to 1, 2, 3. Everything works fine. However when I print a
report, it displays the value property rather than the label names. For
instance, it displays 1 rather than Yes. What can I do to see the label name
rather than the property value on a report?
Thank you for any help.
Sylvie

 

[akphidelt]

Create a query that you use to generate the report. And in that query create
a custom field with the formula

IIF(label=1,"Yes",IIF(label=2,"No",IIF(label=3,"NA")))

Then use that custom field as your report value

 

[Klatuu]

Actually, it should be in the control's controls source, so the syntax should
be:
IIF(label=1,"Yes",IIF(label=2,"No",IIF(label=3,"NA")))
=IIf([Field] = 1, "Yes", IIf([Field] = 2, "No", "NA"))

But, for simplisity, I would use:
=Choose([Field], "Yes", "No", "NA")