Linked images in report records

johnr_nyc · February 11th, 2005, 04:39 AM

Bill,
As simple as your code is to follow, I can't get it to work. I keep getting an error:

Code:

Object doesn't support this property or method

I have followed the example as closely as I could. Could you offer any Ideas?

Here's what I have:
1. In the table, a Text field called "picture_name" which holds the path and file name of the .jpg
2. created a report, added a Bound Object Frame called "imgImage" with a control source of "picture_name"
3. added your code to Modules:

Code:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

If IsNull(Me("picture_name")) Then
  Me![imgImage].Visible = False
Else
  Me![imgImage].Visible = True
  Me![imgImage].Picture = Me![picture_name]
End If

End Sub

Thank you,

John in NYC

JpJoe · February 11th, 2005, 06:23 AM

John,

Your Syntax is probably incorrect. try this

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

If IsNull(Me![picture_name]) Then
  Me![imgImage].Visible = False
Else
  Me![imgImage].Visible = True
  Me![imgImage].Picture = Me![picture_name]
End If

End Sub

johnr_nyc · February 11th, 2005, 12:59 PM

JpJoe,

Thanks for the guidance, but that did not correct it. I tried a couple different variations, none worked.
But, when I get the error message and click "debug" the highlighted line is:

Me![imgImage].Picture = Me![picture_name]

but that line seems to be correct. ...guess I need more guidance.

John R