I used to have an ID badge database that stored the digital pictures in an
OLE field. There was an OLE control on the form which, when clicked, would
let you browse to select the file. With only 100 or so employee records, the
database bloated to over 200Mb. I have since modified the database to get
rid of the OLE field and control. I'm now storing the path to the picture
in a text field called FilePath and the database is under 200Kb. I've got
an unbound image control on the form, and in the form's OnCurrent event I
have:

Me.Image7.Picture = Me!FilePath

which will change the picture to match the picture you assigned to the
current record. When you click the image control, the user browses to the
picture they want to assign to the current record. It works with both JPG
and BMP files.

"Michelle" wrote in message
...
Sorry about that!
I have form that I want to show a digital camera picture.
I have the table field set up as an OLE Object.

Can I load the picture from the form, or do I need to go
to the table, find the correct record for the field,
select Insert object and the browse to the correct digital
camera picture? There's got to be an easier way for end-
users!

I see that bitmap is an option, but my digital camera
pictures are jpg. How do I upload these?

Thanks,
Mich