I have a little project in Access 2007 where I have to add a Traffic light image in my Report form. Depending on a certain value in my Sql query the traffic light image changes to either red, orange, yellow or green. The traffic light is only a circle and with color either red, orange, yellow or green.
I've been looking in access 2007 but i don't see a control that will represent a traffic light. It has button, dropdowns, lines, checkboxes and other activex control etc. but not a simple circle.
Any idea how can i create this traffic light image in my report and also code it to change color depending on acertain value?