I have a continuous form in an Access Data Project (2003) that requires certain key records to be displayed in red. Because I have more than 3 conditions, I cannot use conditional formatting. I tried using the FormatCondition objects in VBA code to try and extend the three condition format limit to no avail. I used recordsets to no avail either.

Let us say there are 100 records, records with ID 37, 59, 62, 86, 87, and 97 need to have all the textbox controls displayed so that the font is formatted in vbRed for example. The details of formatting are not relevant as is displaying the correct records.

Any suggestions would be appreciated.

Continuous forms are problematic this way. I would use the On Current event of the form and do something like this:

If Me.ID = 37 Or Me.ID = 59 Or Me.ID = 62 Or Me.ID = 86 Or Me.ID = 87 Or Me.ID = 97 Then
   Me.ID.ForeColor = vbRed
   Me.ID.FontBold = True
Else
   Me.ID.ForeColor = vbBlack
   Me.ID.FontBold = False
End If

This will check every record and apply the conditions. However, I think that this may not work in a continous form. If any condition is met, all the fields will be red and bold.

This works well on the Detail Section's On Format event on a Report, but continuous forms don't have this event. Can you display it in a report?

mmcdonal

Look it up at: http://wrox.books24x7.com