Embedded image as an OLE Object in table doesn't display in form. Why?

[Michael R]

Hello all.

I created an Image field in a table. I set it to be an OLE Object data type. Later I viewed the table in datasheet view and insereted an image to each row of the Image field. Then I created a form based on that table, with a Bound Object Frame control to display [Image]. However, when I view the form it only displays a white box with the image file name.

Why is it so. How can I display it properly, using the OLE Object data type?


Please help,
Michael.

[nico5038]

It's best to store images as so-called BLOB's and not as OLE-objects as they consume extra space and have some nasty side effects.

Checkout:
http://www26.brinkster.com/alzowze/home.asp (See samples on lefthand side)

http://www.jamiessoftware.tk/articles/handlingimages.html

Nic;o)

[puppydogbuddy]

Hello all.

I created an Image field in a table. I set it to be an OLE Object data type. Later I viewed the table in datasheet view and insereted an image to each row of the Image field. Then I created a form based on that table, with a Bound Object Frame control to display [Image]. However, when I view the form it only displays a white box with the image file name.

Why is it so. How can I display it properly, using the OLE Object data type?


Please help,
Michael.

You can go to the Employees form in the Northwind Sample DB that comes with Access and compare the setup with yours. The property settings for the bound object frame should look something like the following. Am assuming that the ole field name is Photo for purposes of illustration:

Name = Photo
Control Source = Photo
Display type = Content
OLE Type Allowed = Either
Visible = Yes
Enabled = Yes
Locked = No

[FishVal]

It's best to store images as so-called BLOB's and not as OLE-objects as they consume extra space and have some nasty side effects.
....

Just one more link:
The BLOB (not the movie!)