Getting photos to print in an image field

A

anthony

This is Access 2007. In my report I have an image field (9 x 6.77 cm).
It exists in the detail section of a subreport and snakes across then
down. The onPrint event for that section reads:

Me.imgPhoto.Picture = Forms!frmProfiles!txtPath & "\" & Me.txtPhoto

My problem is that Access doesn't print all the photos. I suspect it's
a size issue as if I reduce the resolution of the photos to, say, 800
x 600, then they all print. However, the resaulting print quality is
not nearly as good as the original resolution

So: is there a way to force Access to be patient and ensure that the
photo will definitely print or, alternatively, if I have to reduce the
size, what is the maximum size that Access will tolerate? Photos are
JPGs and between 1.3 MB and 1.8 MB
 

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