Conditional Formatting

J

JamesJ

I've a continuous form with 3 fields the row. One is a Date field.
How can I set all 3 field's text color to red if the Date field equals
Date()??
I can set the format for the Date field but I would like the other 2 fields
to
have the text red, also.

Any help will be appreciated,
James
 
J

J_Goddard via AccessMonster.com

Hi -

You can use conditional formatting (Format - Conditional Formatting) for all
three. The condition for the two non-date fields will be "Expression Is" ,
and the expression can refer to the date field in the record:

[mydatefield] = date()

The date field itself will have "Field Is" "Equal To" and Date()

and set the format to whatever you need.

HTH

John
 
P

Peter Hibbs

James

Try using exactly the same expression in the other two fields as you
are using in the Date field.

HTH

Peter Hibbs.
 
Top