Image control - No Control Source property in Access 2000/2003?

G

Gino

Question:
Is Image control implemented differently in Access 2007 vs. previous Access
versions? Or is my installation of Access 2003 corrupt?

Here is the problem:
To display images in an image control, in an Access 2000/2003 report, I have
to use a roundabout way (see code below) because -in my systems- the property
tab for the image control does not show a Control Source (where I can set the
field containing path and file name).

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.Image1.Picture = Me.JPGNo1
End Sub

This works to the extent that I can preview the images but when sent to the
printer all images in the report are blank.

Now in Access 2007 I find that the image control HAS a control source
property. So, by setting the control source to JPGNo1, (from an underlying
table), all images happily preview and print in forms and reports with no
problem -and no code- at all.

Is something wrong with my Access installation?
Am I missing some library or references?
How can I print the images that I can actually preview in the report?
 
D

Dirk Goldgar

Gino said:
Question:
Is Image control implemented differently in Access 2007 vs. previous
Access
versions?
Yes.

Or is my installation of Access 2003 corrupt?

No. Or at least, this isn't evidence for it.
Here is the problem:
To display images in an image control, in an Access 2000/2003 report, I
have
to use a roundabout way (see code below) because -in my systems- the
property
tab for the image control does not show a Control Source (where I can set
the
field containing path and file name).

The ControlSource property was only added to the Image control in Access
2007.
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.Image1.Picture = Me.JPGNo1
End Sub

This works to the extent that I can preview the images but when sent to
the
printer all images in the report are blank.

That's odd. When I use that same technique in a report with an image
control, the pictures are printed properly.
Now in Access 2007 I find that the image control HAS a control source
property. So, by setting the control source to JPGNo1, (from an underlying
table), all images happily preview and print in forms and reports with no
problem -and no code- at all.

Yes, it was a much-requested improvement.
How can I print the images that I can actually preview in the report?

I think what you're doing now ought to work. I don't know what's wrong.
 
G

GinCan

Thank you very much Dirk for the prompt and comprehensive response.
I am glad to hear that my code is right and that the images should be printed.

I remember that I could dynamically print pictures in Access 2003 and
earlier version but I don't have the old databases so I could not double
check if I was using a different code. I therefore guess that my current
printing problem might be due to memory or some other strange conflict.
________________________________________________________________
 
D

Dirk Goldgar

GinCan said:
Thank you very much Dirk for the prompt and comprehensive response.
I am glad to hear that my code is right and that the images should be
printed.

I remember that I could dynamically print pictures in Access 2003 and
earlier version but I don't have the old databases so I could not double
check if I was using a different code. I therefore guess that my current
printing problem might be due to memory or some other strange conflict.


I'd be interested to know if you figure out what the problem is.
 
G

GinCan

Hi Dirk,
almost a year ago I reported that images I could see in report preview would
actually be totally blank when printed.
At the time I thought it might be due to differences between Access 2007
(with image control source property) and previous versions that did not have
that property.
You kindly assisted me confirming at least that the code I was using was
correct and asked me to let you know if I eventually figured out the problem.

I have recently revisited the database and finally discovered that the non
printing issue was not due to Access at all but to printer settings. The
printer (a Brother Multifunction) at the PC I was using was set for "Fast
Normal" instead of "Normal" and that caused the graphics not to print.
I had not realized this at the time because the difference in text print
quality between the two modes is barely visible and it never occured to me
that the Fast mode would prevent graphics printing instead of simply lower
quality prints.

Anyway thank you again.
Gino
 

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