I would greatly appreciate if somebody could help me with a report design. I am designing a report for a large collection of documents. What I would like to do is to change the back color of the detail section of the form to yellow to give it a highlighted effect, if the document is current based on a field called DOC_STATUS.
The value of DOC_STATUS is: ?Obsolete? or ?Current? or ?New?. I would also like to change the back color of the detail section to light blue if the document is classified as ?New? and leave the back color of the detail section transparent.
Here is an Example of the report:
Doc Number Title Creation Date Status
0019920-B M Prod Spec 01/01/01 Current
0002511-A N Prod Spec 01/01/99 Obsolete
As an alternative, I would like to change the font color for the each record based on the DOC_STATUS
Conditional formatting does not work for me, because the attribute I want to change is not of the DOC_STATUS? text box.