add picture to report "shank" <shank[ at ]tampabay.rr.com> 15.08.2006 20:36:44 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... [Quoted Text] >>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!

Re: add picture to report "bob" <exponent[ at ]hotmail.com> 15.08.2006 22:22:37 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/ "shank" <shank[ at ]tampabay.rr.com> wrote: [Quoted Text] >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! > >

Re: add picture to report "bob" <exponent[ at ]hotmail.com> 15.08.2006 23:04:11 [Quoted Text] >unless it is present in a bound control on the form ooops - I meant 'on the report', of course. "bob" <exponent[ at ]hotmail.com> wrote: > > >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/ > > > > >"shank" <shank[ at ]tampabay.rr.com> wrote: >>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! >> >> >

Re: add picture to report "Larry Linson" <bouncer[ at ]localhost.not> 16.08.2006 20:47:08 "shank" wrote > 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