G
Guest
I have created a report which list work tickets with the date the ticket was
authorized for work to begin. i have included a check box that indicates if
the job is complete. I have been asked to change the color of the record in
the report to futher identify what is complete. for example if job number one
is complete the text boxes for that job should be gray, if incomplete the
backcolor it will still be white. i have tried to use the setvalue method
based on the value of the check box. but this turns out to be all or nothing,
either all records are grayed out or all white depending on the vaule of the
check box.
what is the best way to do this on each individual record?
here is a sample of the code:
With CodeContextObject
If (.ckbxComp = -1) Then
Reports![E07 Auth FMR/Drawing Check List]!jobsummary.BackColor =
255
End If
If (Not .ckbxComp = -1) Then
Reports![E07 Auth FMR/Drawing Check List]!jobsummary.BackColor =
16777215
End If
End With
authorized for work to begin. i have included a check box that indicates if
the job is complete. I have been asked to change the color of the record in
the report to futher identify what is complete. for example if job number one
is complete the text boxes for that job should be gray, if incomplete the
backcolor it will still be white. i have tried to use the setvalue method
based on the value of the check box. but this turns out to be all or nothing,
either all records are grayed out or all white depending on the vaule of the
check box.
what is the best way to do this on each individual record?
here is a sample of the code:
With CodeContextObject
If (.ckbxComp = -1) Then
Reports![E07 Auth FMR/Drawing Check List]!jobsummary.BackColor =
255
End If
If (Not .ckbxComp = -1) Then
Reports![E07 Auth FMR/Drawing Check List]!jobsummary.BackColor =
16777215
End If
End With