some photos don't show in my report

[Guest]

I have a database for artwork that shows images of some of the pieces in a
form. The image files (.jpg) are all in the same folder as the database.
There is a field in which I entered the name of each image in order to direct
the database to find it. All of the images I've provided appear in the table
input form.

I created a report using the wizard to show all of the pieces in the
database for which I have images. For some reason, a number of the images do
not show up when I view the report. I thought maybe I saved these images
differently from the rest, but have done a few tests and still get the same
results. Why might this occur?

 

[strive4peace]

Hi Suz,

if you have the path and filename stored, or can construct it at
run-time, here is something that should work for you (or that you can
draw an anology to if your image path is set and you are just storing
filenames)... put it on the PRINT event for the section your image
control is in...

'~~~~~~~~~~~~~~
If Dir(Me.controlname_PathFilename) <> "" Then
Me.controlname_Image.Visible = True
Me.controlname_Image.Picture = Me.controlname_PathFilename
Me.controlname_lblNoImage.Visible = False
Else
Me.controlname_Image.Visible = False
Me.controlname_lblNoImage.Visible = True
End If
'~~~~~~~~~~~~~~

and then here are some considerations...

Reduce on printing images in reports, by Stephan Lebans
http://www.lebans.com/printfailures.htm

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*