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]
Else
Me![ImageCtrl].Picture = ""
End If


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.
WHY??

What am I missing with the Report/Open option as opposed to the Report/Print Preview option?

Thanks for any ideas and assistance.


mshemari