change color of textbox on printed report

[Xiphiaz]

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

 

[dhookom]

You should be able to use conditional formatting (version 2000 and later). If not, you could use code in the On Format event to the section containing the controls.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.