Attachment Field not displaying image in a Attachment control on a form

Question

I have an attachment field in a table (PartPic). In datasheet view I selected a .jpg image as the only file in the attachment. In form design view I dragged the PartPic parent field to the form and also the PartPic.Filedata child element to the form giving me 2 attachment controls. In form view neither attachment control displayed the image. Aslo, hovering over either control does not cause the mini tool bar to display. At one point in my testing I saw a message on the status bar explaining that hovering over the control is necessary to get the mini toolbar. The message displayed as long as the form was open regardless of where the cursor was located. No I no longer get the message at all. I put the 2nd attachment control on the form because in a report I created years ago I had a working attachment and it had the child element as the control source (PartPic.Filedata).

---

jperry

Answer 1

Hi. Just a guess but try adding a new Attachment control on your form and bind it to the actual name of your attachment field - not the Value or Filedata. Hope it helps...

Answer 2

Hi. Are you able to share a test version of your db?

Answer 3

This is my 2nd try at a reply. I somehow lost the other when I clicked on "mark as answer".

We don't have a test database, and I don't have time to create test data.

In any event, I marked this as answered because I put 2 attachment controls on another form, one with the control source set to the field name (PartPic) and the other to filedata (PartPiuc.FileData). Both displayed the images correctly. So I concluded that my problem form is probably corrupt. A similar problem with controls happened to the same form a month ago and the only way I could fix it was to rebuild the form. I will probably try that again when I have time, but for now will stick with storing the file path in the database and using an image control.

Thanks to all for your assistance, it helped me determine what the probable cause was.

---

jperry

Answer 4

Hi. Glad to hear you got it sorted out. Good luck with your project.