Conditional formatting working inconsistenly

[sjl]

I have a subform with 6 variables, 4 are date variables.

I have conditionally formatted 3 of the date columns to be bold and red if date is between Now() and 01/01/2015

However, the one date field does not consistently bold/red the dates if they are after today! It is a calculated field, but so is one of the other fields that consistently does format as instructed.

Any idea what I should check for?

 

[KeithG]

Can you post an example db?

 

[sjl]

thanks Keith,

When I zip the dbase it is >> 100 kb (the max I can attach)...

However, I had stripped all the data out (I'm still developing it) and ran the Access repair (again), and now it seems to be behaving

If it acts up again, I'll re-post with some sort of example.

-s

 

[KeithG]

okay, do a compact and repair once you strip out the data and any database objects to reallocate the space they were taking up.

 

[Cosmos75]

Not sure if this is any help but it is worth knowing about.

From AllenBrowne.com - Flaws in Microsoft Access: Conditional formatting

If you apply conditional formatting to calculated controls, you may start an endless loop where the form recalculates continually and fails to display the results.