 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / January 2007set a report to color result sets, e.g. team A in blue B in red
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? > 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? 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  SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com 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. Signaturehth 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." >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? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.