Change color of textbox on report

[Xiphias]

Hi,

Im trying to change the color of a text box on a report that im printing
from a form.

On the form I got a check box that has to tricker the color of that textbox
on the printed report.
If checked color is red else just black.

But I dont know how to do it.

I think I have to put the string in the open event of the report, but I have
tried some things, but I only get errors

Please help me...
Xiphias

 

[Steve Schapel]

Xiphias,

I am assuming the check box is bound to a field in the form's record
source, and as such it can also be included in the report's record
source. If you are using Access 2000 or later, you can use Conditional
Formatting applied to the textbox on the report, available via the
Format menu of the report design.