I am using:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me![imageframe].Picture = Me![imagepath]
End Sub

In a sub-report of a report to attach a picture or pictures.

It works pretty well *but* when doing a print or print preview the "Importing <image path and name>" dialog box appears some 6 or more times. And then the e-mailed .snp file is some 10 times the size that it should be.

Is it because I am using a sub-report in a report?

Importing Message is typical and can not be avoided ...

there are some functions to disable it but to no avail here it does not ...
Access has to import each image ...

One note on your code ...
you should provide there if an image file is available or not ...

To remove the dialog box (if your pics are *.Jpg), you'll need to do a small registry edit.

Go to:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Graphics Filters\Import\JPEG\Options

and set ShowProgressDialog to NO.

HTH

Ok, thanks for the help. And I found out why it is doing it so much as well as making the .snp file so large.

It is the setting on the camera taking the photo. It is set on the highest resolution and the pictures are like 6mb in size.

Glad you sorted it out