dynamic(?) report data

[dott]

I want to make it so that for each record it does a test and if it passes this test it will change the font of a text box

one would think the onformat event crap would be where i would look but i dont seem to have any luck making it work

any ideas?

 

[Fizzio]

Post your current code you are using.

 

[dott]

If (Me.WCB_Valid_Date < #6/30/02#) Then
Me.lprojno.ForeColor = 255
Else
Me.lprojno.ForeColor = 0
End If

I now think perhaps my comparison operator is incorrect?
Can you even test dates in this manner?

 

[Fizzio]

Code is fine except you do not need brackets around the if statement but you need it on the On_format event of the section where the controls are (probably detail)

 

[dott]

ah ok thanks, if i could read i would have noticed that i used the wrong date and that was the problem

Thanks.