Unanswered: OLE bound frame - picture showing as icon
I have a table containing employee pictures. My field is set up as an OLE object. When I insert the picture (from file - jpg), it shows only as as icon. If I double-click, it will open picture manager.
How do I make my form display the picture instead of an icon?? I have the same problem with adding it to a report!
I don't know about the direct answer to your question, but I use a slightly different method for a similar table.
I store the file path for the picture for each employee in the table. Then on the form, do an Insert > Picture..., and insert any random picture. Double-click the picture to get the properties, and delete the Picture path property (this will give you an empty frame that you're after). Set the Picture Type to Linked. I also choose to set the Size Mode to Zoom, but that's your call.
On the On Current event of your form, do like
Me.PictureControl.Picture = nz(dlookup("[FldPicLocation]","TblEmployees", "[FldPrimKey] = " & me.FldPrimKey),"")
or something of the sort.
For your report, do something similar, but on the On Format event.
I think if you have your pictures set to Embedded (as opposed to Linked), the report may load quicker. However, this may make your overall database load slower as it is significantly bigger. And you may also start having to worry about that pesky 2GB cap. With that much data, you're going to be a little slow either way you go I think. Just a thought...