Conditional Formating HELP

[RJL1]

I have a report that shows all open orders from previous days. I want to make all orders 2 days or older BOLD. The age of the order is deternime by the download dat (date we got the order) I would like to make the entire record BOLD but the order munber will be suficient.

Thanks
RJL1

 

[mp9]

Assuming your date text field is in the Detail section of the report, you need some code like this in the Detail section's OnFormat event. In this example, the date field is called txtDate:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    If txtDate < Now() - 2 Then txtDate.FontWeight = 800
End Sub

The weight of plain text is 400.

http://www22.brinkster.com/accessory/