how to display images from a folder in a ACCESS report

H

hassan

I SAVE PHOTO FOR EACH RECORD IN MY TABLE BUT I CAN NOT PRINT THE PHOTO IN A
REPORT.
I REALLY APPRECIATE IF SOMEBODY HELP ME
THANKS;
HASSAN
 
B

Bill

Hassan,
First, you need to have an image control in your
report, sized to your liking. In that control, set
the Format Properties Picture to either a default
JPEG image, to be printed if the record does not
have a JPEG imaged named, or leave it empty.

In the Detail_Format Event, set the Picture
property to the name of the JPEG image that
corresponds to the current record. E.g.,
Me.MyImageCtl.Picture = "c:\MyAppl\Images\RecJpeg.jpg".
If there isn't any image specified in the current
record, set the visibility of the control to FALSE,
otherwise allow the default image to show.

"Picture Type" property should be "Linked",
"Size Mode" probably "Stretched" and "Picture
Alignment" probably "Centered".

Note that the size properties of your image control
need to match the aspect ratio of the images you
have in your image library, lest you have un-desired
distortion when your reports print. Also note that
the printers quality attribute needs to be at least
NORMAL, or the image will not print.

Bill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top