Solved

Images are viewable in Preview, but do not print?

Posted on 2004-04-24
5
249 Views
Last Modified: 2012-06-27
I am printing a report with images.  I can see them fine during the print preview screen but they come up blank once I print the report.  I images are linked to the OLE as "Microsoft Word Picture" that is what I see when I view them in the table.  

I am just learning Access.  I have Access 2003.  
0
Comment
Question by:BariWatkins
  • 2
  • 2
5 Comments
 
LVL 16

Expert Comment

by:ahmedbahgat
ID: 10911054
you need to use different  image format, try the following formats, jpg, tif, gif, and so on


cheers
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 10912289
How many images are you likely to store?
If a lot then I would recommend you store the filename path instead of the image itself, the DB gets large very quickly with images loaded

you load the picture into a image control on you report, something like Me.imgPic.Picture = ...

0
 

Author Comment

by:BariWatkins
ID: 10913396
I am not going to have that many images.  I am also not sure how to link the images and then be able to veiw them on the forms and reports, if I use your suggestion of filename path.

I just dont understand why my print preview shows the images, but none when I print.
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 10913755
did u try a different image format like suggest by AB
0
 
LVL 16

Accepted Solution

by:
ahmedbahgat earned 500 total points
ID: 10914500
this is a known problem in access and possibly all MS product, it is hard to explain but the bottom line it is related to ActiveX control capabilty to render images, this will be successful on screen but when you print it will not be rendered, this behaviour is obvious if you export access reports that contain images to an snp format, "Snap Shot Format", the snap shot format will appear ok on screen but when you print it all images "depends on their types may not be visible",

I faced this problem about a couple of years ago and as far as I remember the solution was to use different imgae formats, that solution was an MS solution and not mine really, I just can not find where is the article




cheers
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Can not open the Access Help ? 3 53
Any Way to Print an Import Spec? 3 29
Access query expression 6 20
Archiving Access table older than 6 months 9 39
Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question