Posted 19 June 2008 - 01:55 PM
Here is my setup:
I have MSAccess 2007 operating in compatibility mode (2003) linked to Excel (also running in compatibility mode (97-2003)) sheets as a datasource. One of the fields in the Excel sheet is a full path file specification to a .jpg picture file, one file specification (picture) per Excel row.
In Access, I have created a report based on the Excel spreadsheet's data.
The report has a Group Header section that would generate a header for each Excel row.
In the Group Header section of the report, I placed an Image control.
In the Group Header's On Format event, I placed the following code:
If Not Me![PictureFileSpec] = "" Or Not IsNull(Me![PictureFileSpec]) Then
Me![ImageCtrl].Picture = Me![PictureFileSpec]
Me![ImageCtrl].Picture = ""
Where PictureFileSpec is the fullpath data coming from the Excel table.
Other pertinent ImageCtrl properties are:
Size Mode = Stretch
Picture Type = Linked
The pictures appear IF I view them in Print Preview mode.
They do NOT appear if a simply Open the report and view each record.
What am I missing with the Report/Open option as opposed to the Report/Print Preview option?
Thanks for any ideas and assistance.