Conditional format IF record value = "value"

  • Thread starter Thread starter Mikael Lindqvist
  • Start date Start date
M

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
 
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]...
 
Back
Top