View Full Version : Linked Images in Reports


pwhite
12-09-2002, 08:53 AM
I am working with a front-end Access Report. I am trying to link an Image object to a path located in a backend SQL database table (column datatype: varchar [text]) I have successfully linked these image paths in my forms to this column, but for some reason, when I try this in a report, Firstly, the intellisense in the VB code doesn't show the .Picture property for the Image, and Secondly, it says that it can't find the field I am specifying in the SQL database. I have written the following in the Detail event for the report(like I have seen others in this forum state to do)

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

...where [ImageFullSize] is the name of the 'Image' object and [ImageFullPath] is the column name in the linked SQL database.

Your help is appreciated.
Paul
pwhite@city.woodstock.on.ca