Report data detection

[Matthias]

Hello,

I've got the following problem. I have a database with student marks
(actually my marks). I would like that Access is automatically
inserting a bitmap when I've got a C.
Par example:
For a history test I've gotten a C-. I am typing the data into the
table test result. I am making a report with my results.
I now want Access to insert a picture of a stoplight (red light) right
next to the C-.
For marks B and A I also want to insert a picture of the stoplight
with respectively yellow and green stoplights.
Does anybody know how to solve this?

In advance thank you for any help!

Matthias

[Darryl Kerkeslager]

Use an image control. Set the Picture property to the picture file you need
in your code.
Darryl Kerkeslager

"Matthias" <cl*****@hotmail.com> wrote:

I've got the following problem. I have a database with student marks
(actually my marks). I would like that Access is automatically
inserting a bitmap when I've got a C.
Par example:
For a history test I've gotten a C-. I am typing the data into the
table test result. I am making a report with my results.
I now want Access to insert a picture of a stoplight (red light) right
next to the C-.
For marks B and A I also want to insert a picture of the stoplight
with respectively yellow and green stoplights.
Does anybody know how to solve this?

In advance thank you for any help!

Matthias

[Matthias]

Thank you, but how can I create an image control? Sorry for my
ignorance, but I am a complete noob in Microsoft Access.
Thanks for the help.

[Larry Linson]

"Matthias" wrote

Thank you, but how can I create an image control? Sorry for my
ignorance, but I am a complete noob in Microsoft Access.

In design view of the Form, you'll see the Toolbox unless you have
suppressed its display (by default, I believe it's on the left side of the
screen), and you add the Image Control same way you add any other -- click
it on the Toolbox to select it, then click on the Form where you want it to
be placed. If the icon on the Toolbox with the little "magic wand" is
active, you should get prompting from the Control Wizard. It will likely ask
you what image... give it any image file (you can browse to it), and later
delete that from the Control's properties.

Larry Linson
Microsoft Access MVP