set a report to color result sets, e.g. team A in blue B in red

G

Guest

I have a report that displays a group by different teams. I want the report
to color code the team in a report. IS there a way to do this?
 
R

Rick Brandt

Keith said:
I have a report that displays a group by different teams. I want the
report to color code the team in a report. IS there a way to do this?
Click to expand...

What do you want to color? The background? The text?

Basically in the OnFormat event of the section where the color change takes
place...

Select Case Me!TeamID
Case 1
Me.Detail.BackColor = vbYellow
Case 2
Me.Detail.BackColor = vbRed
etc...
End Select
 
A

Al Campagna

Keith,
You could use the OnFormat event of the report section you want colored.
If Team = "A" Then
'set all the fields forecolor to red
ElseIf Team = "B" Then
'set all the fields forecolor to blue
'etc... for all teams
End If

or... use a Select Case statement to do the same.

--
hth
Al Campagna
Candia Computer Consulting
Microsoft Access MVP - Candia, NH USA
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting in a Report 9
Columned Access Reports 1
multiple instance of report in access 0
Hyperlinking Report Data to a Form Record 2
How can you sort groups in an Access report? 10
Column wrap a single field into 2 or more columns per page? 2
OnFormat Code needed 3
HOW CAN I COUNT ALL THE GROUPS IN A REPORT 1

Top