By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,480 Members | 2,766 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,480 IT Pros & Developers. It's quick & easy.

Report data detection

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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.
Nov 13 '05 #3

P: n/a
"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


Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.