Error 438 for color

[steve711]

Hello everyone. I have a strange new problem, for me at least.

I have a report that during ON PRINT event it needs to highlight dates based on some criteria.

This has been working great for a long time. Now I have decided to add a new column to the mix and use the exact same color criteria as I did before.

Except now when I run the report I get the good old Error 438 highlighting this line of code:

If DateDiff("m", Now, Me.AS_GND_Exp) = -1 Then Me!AS_GND_Exp.BackColor = lngRed

Of course this code is the EXACT same as it is for the other columns of data and they run without any problems. I may have missed something but I don't see it? Any clues as to why when I remove this line life is good, but without color for this column and the other lines go about their busy normally?

I am using Access 2003 w/SP2 if that should be significant.
I also defined lngRed as Long.

 

[Rich]

Try vbRed

 

[steve711]

I have already defined lngRed, lngWhite, lngYellow, lngPurple with there appropriate RGB numbers.

 

[lightray]

Try duplicating an existing column to see if that works (two columns the same) then change the field name.