I'm trying to figure out if I can place a graphic on a report that will change, based on the content of the report. I've made a database that runs stats on data in the report, and I would like the report to include a graphic (red.jpg or green.jpg or yellow.jpg) based on the result (say result is between: 1-10 = Red, 11-20 = yellow, 21-30=green). I know how to add a graphic (insert Image), but I don't know to make the image vary based upon a calculation/result. Any suggestions would be great. Thnx!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
placing a dynamic graphic on a Report
- Thread starter ThomaJo
- Start date
You could add all graphics, one on top of the other and use some code to show or hide each graphic based on the value you want to check.
The code would be placed in the On Format event of the report section that contains the graphics and the required fields bound to text boxes.
Duane
Hook'D on Access
MS Access MVP
The code would be placed in the On Format event of the report section that contains the graphics and the required fields bound to text boxes.
Duane
Hook'D on Access
MS Access MVP
- Status
Similar threads
- Locked
- Question
- Locked
- Question