add picture to report

[shank]

I'm trying to add a picture to my report where the path of the picture is in
the [Pic] field.

The help section has the following blurb...

I don't have an "OnCurrent" property to my report.
What did I miss?
thanks!

 

[bob]

In reports use the ‘Detail_Format’ event, as follows:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
‘ Load the image control here
End Sub

One important difference in reports is that the field which contains (or from which you generate) the filename
will not be retrieved unless it is present in a bound control on the form, so add a text box bound to this
field. You can make it invisible if required.

--
_______________________________________________________
The Access Image FAQ
http://www.ammara.com/access_image_faq/

I'm trying to add a picture to my report where the path of the picture is in
the [Pic] field.

The help section has the following blurb...

I don't have an "OnCurrent" property to my report.
What did I miss?
thanks!

 

[bob]

unless it is present in a bound control on the form

ooops - I meant 'on the report', of course.

In reports use the ‘Detail_Format’ event, as follows:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
‘ Load the image control here
End Sub

One important difference in reports is that the field which contains (or from which you generate) the filename
will not be retrieved unless it is present in a bound control on the form, so add a text box bound to this
field. You can make it invisible if required.

--
_______________________________________________________
The Access Image FAQ
http://www.ammara.com/access_image_faq/

I'm trying to add a picture to my report where the path of the picture is in
the [Pic] field.

The help section has the following blurb...

Click the Build button next to the OnCurrent property box, and then click
Code Builder in the Choose Builder dialog box. <<

I don't have an "OnCurrent" property to my report.
What did I miss?
thanks!

 

[Larry Linson]

I'm trying to add a picture to my report
where the path of the picture is in
the [Pic] field.

In Reports, you use the OnPrint (preferrably) or the OnFormat events instead
of the OnCurrent used in Forms, to set the value of the Picture property of
the Image Control.

The sample imaging databases at http://accdevel.tripod.com illustrate three
approaches to handling images in Access, and the download includes an
article discussing considerations in choosing an approach. Two of the
approaches do not use OLE Objects and, thus, avoid the database bloat, and
some other problems, associated with images in OLE Objects.

If you are printing the images in reports, to avoid memory leakage, you
should also see MVP Stephen Lebans' http://www.lebans.com/printfailures.htm.
PrintFailure.zip is an Access97 MDB containing a report that fails during
the Access formatting process prior to being spooled to the Printer Driver.
This MDB also contains code showing how to convert the contents of the Image
control to a Bitmap file prior to printing. This helps alleviate the "Out of
Memory" error that can popup when printing image intensive reports.

Larry Linson
Microsoft Access MVP