[AccessD] Check Box for certain status

I just did this on a report yesterday. I put the status...in my case
"discrepency" (OptDiscrep and lblDiscrep)...on the form, but setup the
following code in the Print event of the report's detail section. It
worked in my case. I also put a second control there that said "No
Discrepency" (lblNoDisc)
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)

If logDiscrepancy = False Then
    OptDiscrep.Visible = False
    lblDiscrep.Visible = False
    lblNoDisc.Visible = True
Else
    OptDiscrep.Visible = True
    lblDiscrep.Visible = True
    lblNoDisc.Visible = False
End If


End Sub


>>> HollisVJ at pgdp.usec.com 03/07/03 11:26AM >>>
On a report I need a checkbox to be checked if the status is Rejected.
I get
the status from tblStatus, StatusID (autonumber), status, Rejected,
Canceled, Approved, etc....
 
How can I show a Rejected status as a checkbox instead of the word
"Rejected". They are only wanting to show the status if it is
rejected.
 
Virginia