Option group to display on a report

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
 
A

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
 
K

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

labels with group header, detail, group footer sections 7
Display Option Group label name versus value 2
control on form from report 2
Multiple Columns on a Report 1
Report with No data Input 3
Setting up a report for a DYMO labeller 1
Access 2003 Label Report - Text Position On Label Question 7
Subreport page break in label controls or textbox controls 6

Top