Access 2000/Access 2002

[dixxy]

I have a really weird problem.

I have created form with a text box that change colors based on calculated day value (now() - entry date). All this is done with conditional format like this:

Field Value between 5 and 10 background = green
Field Value between 11 and 15 background = yellow
Field Value is greater than or equal to 16 background = red

All this works perfect on my system (using Access 2002), but as soon as I try it on my user systems (using Access 2000) then none of the colors work right!!!

Does anyone know why this is happening?

Is there a way to cure this?

Thanks,

Sylvain

 

[ozzroo]

Hi Dixxy

I think its because conditional formatting only works with Access 2002 and later versions.

You may have to use code to achieve what you want

 

[dixxy]

I thought of using code, but i don't know the syntax of it well enough...i have tired but with no luck...

if someone could help me out on this it would be great.

Thanks,

Sylvain