Conditional Formatting Help

[MAINOH]

I have a report that which contains three fields:
[ASOF] which value is today's date
[DUE] which is the due date of payment.
[PASTDUE] value = "PAST DUE" (the visible property is set to false on this field)

What I am trying to do is have [pastdue] show when ASOF is greater than or equal to DUE.

I have the following in my detail on format property:

If Me.due >= Me.ASOF Then
Me.PASTDUE.Visible = True
End If

The problem is the report has the field in read no matter if due is greater or not.

What am I missing?

Thanks.

 

[rjoubert]

You need to turn visible back to false in an Else block...

If Me.due >= Me.ASOF Then
Me.PASTDUE.Visible = True
Else
Me.PASTDUE.Visible = False
End If