Change the Back Color automatically in a Report

[Guest]

I have a form where I change the Back color of different fields to Yellow or
Red. An I was woundering how to get the same field in the report to change
at the same time. I.e. "Last Name" in the Form highlighted in what ever
color and the "last Name" in the report change automatically to that same
color.

Thanks

 

[Guest]

You can use conditional formatting in both forms and reports to set format
properties based on values stored in the records. In reports, you can also
use code in the On Format event of the section of ther report containing the
control(s).