Hi,

I am trying to add images of our products into my database in order to produce catalogues, bestseller lists etc...

I have created a table, formatted the cell as "OLE Object" and inserted links to images as bitmap files. My problem is then getting any report or form to show the image in anything other than a pixelated mess!! It seems to make no difference how I adjust the images ouside of access (they look great in photoshop!) so I can only assume I've done something wrong in Access?

I've tried adjusting the report propeties (zoom, clip, stretch) but this has no effect... Is it also possible to stop the reports from displaying the file name?

Please help!!

Many Thanks,

Stuart

Hi Stuart

Thankyou for your question

This is a difficult one to answer without actually seeing the database

As a first thought, if you open the form in design view and click on the picture frame, you will get the object's properties.

You will find a size mode property. If it is set to "stretch" or "zoom" try altering that to "clip" or vice versa. It is possible that the wrong setting here is causing your problem

If this doesn't work, or if you've tried it already, please let us know, so we can look at other possibilities

Regards

Stephen

Hi There,

Thanks for your response. I have tried each of the properties (stretch, zoom & clip) with no effect...

Many Thanks,

Stuart