Stuart has attended:
Access Consulting course
Creating Database of Images
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
RE: Creating Database of Images
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
