Using Report Query Fields to Format Detail Controls 2

[Haccess]

Hi. What's the general syntax for formatting report detail controls' forecolor based on the value of a field in the report's data source that isn't shown?

Background: My report's data source includes a field called IS_HIGHLIGHTED (yes/no data type). I want to highlight the forecolor of several detail section controls red if the user checks IS-HIGHLIGHTED for a record in the underlying table.

Thanks!

 

[dhookom]

You can use Expression is in the condition of conditional formatting with an expression like:
[IS_HIGHLIGHTED] = -1

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]