Option group to display on a report

  • Thread starter Thread starter SylvieB
  • Start date Start date
S

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
 
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
 
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")
 
Back
Top