Please help me if you can.

My goal is to organize a bunch of photos in a way I can search for various features. I would like to have a record that displays various things and then have a box at the bottom with the photo in it.

Right now, I have all that, except that the photo is an icon. In order to view the photo I have to double click and open up another program to view it.

How can I have the photo display in access without having to open it seperately?

I can seem to find an answer to this. I've inserted it as the help file instructed but it's still just an icon.

Any solution for me? I'd really appreciate any help I can get on this one as I've got to find some way - ANY way - to get these photos into some sort of order. Thanks. You guys are the best! :) [insert more groveling and begging here]

In your table you need a field of data type "OLE Object." You can then copy and paste pictures into that field in the form.

Thanks. I'll try that.

All I get is an icon for the photo instead of the photo itself. The data type was already set to an OLE Object. :(

Are you copying and pasting the photo? What format is the photo (jpg, bmp...)?

What version of Access?

I'm using Access 2002.

The file is a .jpg.

I've tried copy/paste. Also dragging it over from another window and Insert/Object. When using insert/object, I am not clicking the "display as icon" box.

I get the same results everytime: only an icon for the image instead of a photo itself.

By the way - I really appreciate your assistance with this. Thank you.

One last suggestion and then I'm all out. ;)

Make sure the Display Type in the Properties for that control is set to Content and not Icon. No idea if this will help, but I just noticed this property and thought it might make a difference. (By the way, I'm using 97, not 2002, so it might be something unique to 2002 that I'm not familiar with.)

Figured it out. Yay!

Here's my answer if anyone else was interested (it wasn't me - it was "them")
http://support.microsoft.com/default.aspx?scid=kb;en-us;258644