Change the way it shows in report

[selavarti]

Hi,

I have a report which shows if a tool with certain barcode is active or inactive. I select the barcode and run the report. Every thing is fine..it runs. But in the report it shows the tool name , baroce and if active it shows 1 and if inactive 0. What I want is in place of 1 it should show "active" and in place of 0 "inactive" repectively.
Can anyone tell me how to do this
thanks

 

[sxschech]

In the Control Source field of the Properties Window:
(Remember that you would replace Status with the name you are using for the Active/Inactive field.)

[tt]
=IIf(Status=1,"Active","Inactive")
[/tt]

 

[dhookom]

Other methods
=Choose(Status+1,"Inactive","Active")
or set just
[Status]
with the format property set to
"Active";"";"Inactive","N/A"


Duane
MS Access MVP
Find out how to get great answers faq219-2884.