Conditional Formatting

[Guest]

I have a form that has many fields.

In the [dtmImplementedChanges] field (date field), I would like the
remaining fields to turn a different color if a date is entered in that field.

Is this possible using conditional formatting? And if it is, how do you
write the expression. I've tried but have not been able to get it correct.

Any help would be appreciated.

Thanks in advance!

 

[Allen Browne]

1. In form design view, select the field that must change color.

2. Choose Conditional Formatting on the Format menu.

3. Set Condition 1 to:
Expression [dtmImplementedChanges] Is Not Null
and choose the color you want.

4. Repeat for other fields that must change color.

 

[Guest]

It worked! I really appreciate!!!

1. In form design view, select the field that must change color.

2. Choose Conditional Formatting on the Format menu.

3. Set Condition 1 to:
Expression [dtmImplementedChanges] Is Not Null
and choose the color you want.

4. Repeat for other fields that must change color.

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

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

I have a form that has many fields.

In the [dtmImplementedChanges] field (date field), I would like the
remaining fields to turn a different color if a date is entered in that
field.

Is this possible using conditional formatting? And if it is, how do you
write the expression. I've tried but have not been able to get it
correct.

Any help would be appreciated.

Thanks in advance!