Link to home
Start Free TrialLog in
Avatar of donnie91910
donnie91910

asked on

Changing row colors MSAccess

I need code/instructions on how to change the colors of a row when in the row there is found the following literals in the detail section of the report:

row change color to blue when it finds "Reports"
row change color to yellow when it finds "Meetings"
row change color to orange when it finds "Misc"

thanks in advance
Avatar of crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access

what is the NAME property of the control that is being tested?

To find this out: go to the DESIGN view

show the property sheet if it is not already showing by pressing ALT-ENTER
(the property sheet shows additional details for whatever is selected)

then click on the control with company and get the Name from the first property listed on the OTHER (or ALL) tab
Avatar of donnie91910

ASKER

Work Code
SOLUTION
Avatar of crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thank you.