[AccessD] Check Box for certain status

Virginia

Create an unbound checkbox on the report (cbxRejectStatus).

***************************************************
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.status = "Rejected" Then
	cbxRejectStatus = True
Else
	cbxRejectStatus = False
End If
End Sub
***************************************************

Alternatively, you could add the code to hide the checkbox when the
value is false:

***************************************************
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.status = "Rejected" Then
	cbxRejectStatus = True
	cbxRejectStatus.Visible = True
Else
	cbxRejectStatus = False
	cbxRejectStatus.Visible = False
End If
End Sub
***************************************************


Regards,
Bob Gajewski


On Friday, March 07, 2003 11:27 AM, Hollis,Virginia [SMTP:HollisVJ at pgdp.usec.com] wrote:
> 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
>  << File: ATT00016.htm >>