Controlling Outcome of Access Reports

Myssi · September 8th, 2003, 04:38 PM

Is there a way to highlight or change the font color of certain records in an Access report?

For example, I am creating a contracts database for my company, which lists all of the contracts past and present. I need to print this report out monthly to follow up on any contracts that are going to be expiring within the next three months. Is there a way to highlight or change the font color of only the records with contracts that expire within the next three months, while still showing the rest?

Thanks!!

Melissa White
Procurement Assistant
CCE

BethMoffitt · September 8th, 2003, 06:41 PM

While in design view of the report, click the Status text box. On the
menubar go to Format > Conditional Formatting. A dialog box will pop-up and give you options where you specify your conditions and what format you want to display. There is an 'Add' button so you can specify additional conditions.

HTH,

Beth M

BethMoffitt · September 8th, 2003, 06:44 PM

Sorry... I stated the Status text box because this was a reply to someone else previously on another board... You would select the text box where you want a condition to be met (whatever it may be named), and then set your conditions and formatting.

IMO · September 16th, 2003, 08:02 AM

Or you could use this code if you have an Access version earlier than A2K

Code:

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

   If Me.TheDateField > Date And Me.TheDateField < DateAdd("m", 3, Date) Then
          Me.TheDateField.FontBold = True
          Me.TheDateField.ForeColor = vbRed
    Else
          Me.TheDateField.FontBold = False
          Me.TheDateField.ForeColor = vbBlack
    End If

End Sub

Just change "TheDateField" to the Name of your Date control.

HTH
IMO