Color in Access Reports

[JJOHNS]

I have a report for a list of employees. In each record, there are four checkboxes that tell me something about the employee. On the report, I'd like the record to be highlighted a particular color if one of the four checkboxes is checked.

I've managed to get the form to highlight in color as I click through all the records. Can someone tell how to do it with a report?

 

[SteveR77]

Without knowing how the form is set up. I would tell you to apply the same logic the you used in the form to the report.

 

[ZmrAbdulla]

Hi,
In forms you can use If... Then Statement. But in the case of Reports you have to use If...then...Else
Form
=========================
If Me![Sales] >= 10000 Then
Me![txtSales].FontBold = True
End If
==========================
Report
==================
If Me![Sales] >= 10000 Then
Me![txtSales].FontBold = True
Else
Me![txtSales].FontBold = False

End If
===========================
Regards


Zameer Abdulla

http://www.geocities.com/zameerabd/

http://www.mtkhoory.com