Iff statenent in conditional formatting

[jmk909er]

Can someone help me out with these IIf statements below? I need the days to be >= and <= so that I don't have gaps. when I try to enter it that way I get "The expression you entered has invalid syntax"
This is for conditional formatting to change the back color of a text box. Maybe the word And is messing me up or I need additional parenthesis?? Thanks, Joe

IIf(Now()-[Forms]![frmIntro]![Data Changed]>20,True,False)
IIf(Now()-[Forms]![frmIntro]![Data Changed] Between 14 And 19,True,False)
IIf(Now()-[Forms]![frmIntro]![Data Changed] Between 6 And 13,True,False)

[LillMcGill]

You just need to enter the statements wherein the format should be turned on. No IIF here.
Now()-[Forms]![frmIntro]![Data Changed]>20
or even use
Now()-[Data Changed]>20

[pbaldy]

Also, this may be one of those places where Between won't work. If so, you'd need >= And <=. You don't actually need it anyway, as you can rely on the fact that Access will evaluate the expressions in order, so your 3 tests are:

Blah > 20
Blah > 13
Blah > 5

By the way, you probably want to use Date() rather than Now(), as your existing test could have a decimal remainder that could leaving it failing all tests (like 13.5).

[jmk909er]

Thanks Lil,and Paul I did it the way you suggested and it is working great. Much simpler and cleaner. I guess I was over thinking it. -Joe