Change Font Color in Access Report Based on True/False value of another field

[kirkrossi]

In access report, I'm trying to change color of text in specific records based on the true/false value in another record. Works in forms using conditional formatting, but won't seem to work in a report. Here's what works in forms:
IIf([2009 Symposium]=true, forecolor=255 ....this changes the records to red.

But using the same expression in a report doesn't change the text color. Any thoughts?

 

[MarkK]

You need to run that code in the Format event of the report section in which the control appears.

 

[MarkK]

Please don't double post

http://www.access-programmers.co.uk/forums/showthread.php?p=1271429&posted=1#post1271429