Conditional format IF record value = "value"

[Mikael Lindqvist]

Hi,

I wonder how (assuming it's possible, using expression value) I can use
CONDITIONAL format so that it formats a specific field in my report if
another field has a specific value?

In my case I have invoice number, that I want to format, if a reminder has
been sent out (both are field values in same table).

Kindly,
Mikael
Sweden

 

[Allen Browne]

In report design view, select the invoice number text box, and choose
Conditional Formatting on the Format menu.

Set up Condition 1 to:
Expression: [Reminder] = True
substituting your field name for Reminder.
(This assumes Reminder is a yes/no field.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...