Change font color if date expired 2

[royweb]

To indicate certain records are expired, I want to generate a report that the font color of the field would change (to red) if the date value is greater than today. Please help. Thank you.

 

[dhookom]

You should be able to do this with conditional formatting. Check it out and come back if you have questions.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[royweb]

I'm using Access 97. Is conditional formatting available in that version?

 

[dhookom]

No, you will need to use code in the On Format event of the deatil section of your report. It would really help to know the names of your controls however, consider this code:

If Me.txtDateControl > Date Then
   Me.txtDateControl.ForeColor = vbRed
 Else
   Me.txtDateControl.ForeColor = vbBlack
End If

You would need to substitute your control name.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[royweb]

Thank you! It works.