Hi,
I have below code its not work
I want when remain is value zero font green
when remain value is less than zero i want font color for remain with red
when its bigger than zero font color with yellow
Me.remain = Me.amount - Me.fpay - Me.spay - Me.tpay
If Me.remain.Value = 0 Then
Me.remain.ForeColor = RGB(0, 255, 255)
Else
If Me.remain.Value < 0 Then
Me.remain.ForeColor = RGB(0, 2, 255)
Else
If Me.remain.Value > 0 Then
Me.remain.ForeColor = RGB(0, 2, 255)
End If
End If
End If
End If