Conditional Formatting in Access 97

[rbliss]

I am fairly new to this, so please excuse me for not having the proper verbage.

I have created a report in Access 97, with the following information:

Date open, Expected Date of Completion, and Date Closed.

I run reports weekly on all open items. What I need to do is to be able to format the font to turn red in the Expected Date of Completion field if today's date is after the Expected Date of Completion.

Or another scenario might be:
If today's date is 90 past the Date Open field, then turn the font in the Expected Date of Completion Red.

Please Help!

Thank you in advance for any suggestions.

Robin

 

[Norie]

Robin

I'm afraid that, as far as I recall, there is no conditional formatting in Access 97.

The only way I think you can do what you want is via VBA, and I'm not 100% sure how you would do that, or if it is in fact possible.

I'll take a look into it and post back.

 

[rbliss]

Norie,
Thank you for any help you can provide.
Robin

 

[Tanis]

Unfortunately, Access 97 does not have conditional formatting. So, you will have to 'roll your own' In the On Format property of the report put something like this.

Dim YourControlName as String
Const vbRed = 255
Const vbBlack = 0

If Me.YourControlName = YourTest Then
Me.YourControlName.ForeColor = vbRed
Else
Me.YourControlName.ForeColor = vbBlack
End If