dunner44,
In the OnFormat event of the Detail Section of your report you can place the following code:
'***************************************
Option Compare Database
Option Explicit
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.TextBoxName > 100 Then
Me!TextBoxName.ForeColor = vbRed
Else
Me!TextBoxName.ForeColor = vbBlack
End If
End Sub
'***************************************
Hope this helps.