Help with Access 2010 Conditional format

[zippy483]

Good Morning all

I have a quick question about formatting a filed in an access 2010 report?

Firstly I thought there was a limit of 3 rules on conditional formatting I tried to add additional rules and there seems to be no problem doing that.

And they all fire with varying degrees of success the one I seem to be struggling with at the moment is the following

IN ENGLISH

If the frequency is 3 and todays date is between 56 and 121 days From the stored date turn the cell green

So I have in the expression as follows

[Frequency]=3 And (Date()>DateAdd("d",56,[Date]) And Date()<DateAdd("d",121,[Date]))

I also have a second expression that is supposed to be

Turn cell red if Frequency = 3 and when today is greater then 4 Months (121days) from the Stored date. that expression is

[Frequency]=3 And (Date()>DateAdd("d",121,[Date]))

The first expression fires Ok but when I change [Date] to >121 days and then back to between 56 and 121 days the formatting doesn't change as I'd expect it changes between red and green at about 90 days from stored instead ?

I have a number of other essentially identical rules for Frequency = 36, 24, 12, 6 and 1 month

Any Ideas?

Is it because I have more then 3 rules in the conditional formatting or are my conditions a little iffy?.



Many thanks

Zippy483

[CJ_London]

duplicate post here

http://www.access-programmers.co.uk/...52#post1459152

@zippy - recommend you read this thread

http://www.excelguru.ca/content.php?184

[zippy483]

Point taken, My apologies

[CJ_London]

Not a problem - just make people aware that you have posted to other forums by providing a link so they can see if what they are going to spend time suggesting something that has already been posted