[AccessD] Check Box for certain status

You don't need that much code.  This works just as well.

cbxRejectStatus = (Me.Status = "Rejected")

Or you calculate a field in the underlying query like this:

RejectStatus: [Status]="Rejected"

Then you could simply bind the checkbox to that calculated expression.

Charlotte Foust

-----Original Message-----
From: Bob Gajewski [mailto:bob at renaissancesiding.com] 
Sent: Friday, March 07, 2003 9:09 AM
To: 'accessd at databaseadvisors.com'
Subject: RE: [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 >>

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com