Format Negitive figure to Red in Reports

[jmonty]

In report design mode, on the View menu select Code.
Select Detail...

Private Sub Detail_Format(Cancel As Integer, FormatCount
As Integer)
If Text1 < 0 Then
Text1.ForeColor = vbRed
' This will display negative numbers in red
End If
End Sub