Formating a textbox in an Access '97 report

[dunner44]

In a report, what is the formula for a conditional format. Say if my textbox value is greater than 100, how can I format the font color to be red?

Unfortunatley Access 97 doesn't have conditional formatting.

TIA

 

[bkpchs237]

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.