Hi All,

In my db i have a report called ClientOrders. This is opened in Print Preview to show multiple orders with productphoto's.
This is an unbound image control and will show the picture of the hyperlink: Hyperlink Artwork BLE. With the following code on the event 'on format'.
On Error Resume Next


If Me.Hyperlink_Artwork_BLE Is Not Null Then
Me.ImageFrame.Visible = True
Me.[ImageFrame].Picture = HyperlinkPart(Me.[Hyperlink Artwork BLE], 2)
End If

The code does work, however it doesn't work allways, with multiple orders (for example 5 on one page) it will show 4 images, one not. The next page it will only show 2 or 3 and leave the remaining grey.

I have no idea how to solve this. I have other reports with a max of 4 images (per order), with the same code and this works good. I've seen one report where it loaded only 3 images, restarting the db fixed this and i haven't seen it again.

Does anyone know why some images aren't shown (while the hyperlink works and the image does show in the form behind the report)?