Conditional Formatting in Access 97

[arogers via AccessMonster.com]

How can I apply conditional formatting to fields in a form in Access 97. I
know there is conditional formatting in Access 2000 onwards, unfortunately, I
have Access 97. I want to be able to change the background colour of a date
field as soon as the date a passed the current date or by a specified number
of days passed the current date.

Many thanks

Allan

 

[NthDegree]

You could try something like this:

1. Open the report in design mode.
2. Right click on Detail section heading.
3. Left click on Build Event
4. Use the following type of code.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

If DateField1 > #somedate# Then
DateField1.ForeColor = 255
Else
DateField1.ForeColor = 0
End If
End Sub