Link Image

[Andre T.]

Can anyone help me with a simple image linking question?

I have a field which accepts the path of an image file. I'd like to put
this image logo on a report. In another word, whereever the user specified,
the image should appear on the same spot. 3 questions I have:

1) which control should I use?
2) how do I dynamically link this control to the image file?
3) how do I resize the image file so it always fit in the control area I
created?

I've tried the Image control, but don't know how to dynamically link to the
image and it always come out the image file's size, not my control size.

You advice and comment are appreciated.

Andre T.

 

[Larry Linson]

There are example programs illustrating three approaches to handling images
in Access that you can download from http://accdevel.tripod.com/ -- they
deal with forms, but reports are similar. They don't do exactly what you
want, but they certainly illustrate how to use a file-path-and-name to set
an image.

For details on eliminating / reducing memory leakage in reports using Image
Controls, take a look at MVP Stephen Lebans' site, http://www.lebans.com.

Larry Linson
Microsoft Access MVP