Highlight Record Based on Criteria 2

[wonderwhy]

Hello!

What is the best way to highlight certain records in a report based on the value of a field (like all records where the field called Status = "Complete&quot.

Thank you so much for your help.

Julia

 

[CosmoKramer]

If by highlighting you mean something like bolding you could do this:

In the On format event of your detail section, put code like this:

If Me.Status = "Complete" Then
   Me.txtField1.FontBold = True
   Me.txtField2.FontBold = True
Else
   Me.txtField1.FontBold = False
   Me.txtField2.FontBold = False
End If

This will bold all controls listed if the Status field meets the criteris....Just include all detail fields...

 

[wonderwhy]

Thank you CosmoKramer! I would really rather change the background color of the records where status= "Complete" to a light gray. Can you explain how to do this, too?

Thanks again,

Julia

 

[CosmoKramer]

Sure, try this:

If Me.Status = "Complete" Then
   Me.Detail.BackColor = 12632256
Else
   Me.Detail.BackColor = vbWhite
End If

 

[wonderwhy]

This works great! I put it in the On Format property of the detail section.

Thanks!

Julia