Coloring results in a report?

[robertsdgm]

Hello All
Is there a way to color the results in a given report based on where the value happened to come from..
In other words..my query gathers data from two tables.
In the report I want the values from the first table to be in black..and those values from the second table to be in blue.
thks
Dan

 

[smedvid]

In the Detail Format section, you can code specific formats of objects.... In my example below I color an entire line a different color. htwh,

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.Detail.BackColor = vbWhite Then
Me.Detail.BackColor = 15461355
Else
Me.Detail.BackColor = vbWhite
End If
End Sub


Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...