Conditional Formatting for Access 2016

Question

I have a text box with this control source:

=IIf(Date()>[Due Date] And [Progress]<100,"Late"," ")

I then want to use conditional formatting to make it red if it is Late

I'm trying "Check values....." and selecting "Field Value is"  Equal to "Late"

Then setting the colours to red

This is not working.

Any ideas?

Answer 1

Instead of the field value try using the expression as the basis for the conditional formatting:

Date()>[Due Date] And [Progress]<100

Answer 2

Just tried that - no - it didn't have any affect.

I also tried trying to change the back style to normal but that results on all rows being red

Answer 3

On the basis of the information you've provided I see no reason why it should not work.  Can you post an image of the conditional formatting dialogue exactly as you've entered the criteria.

Answer 4

Thanks for your reply - here are the screen shots

this is for the conditional formatting as you suggested

And this is the control on the text box

Answer 5

The dialogue is showing the text colour to be red on the basis of the expression, but the preview shows the background colour to be red.  For the latter I'd expect:

For the former the preview would be expected to show the text in red, not the background.  Try deleting the formatting rule and then create it again, setting the colours to what you want.