none
Attachment Field not displaying image in a Attachment control on a form RRS feed

  • 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

    Saturday, March 23, 2019 10:33 PM

Answers

  • Hi. Are you able to share a test version of your db?
    • Marked as answer by jperry Tuesday, March 26, 2019 5:23 PM
    • Unmarked as answer by jperry Tuesday, March 26, 2019 5:25 PM
    • Marked as answer by jperry Tuesday, March 26, 2019 5:26 PM
    Monday, March 25, 2019 10:16 PM

All replies

  • 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...
    Monday, March 25, 2019 3:22 PM
  • Hi. Are you able to share a test version of your db?
    • Marked as answer by jperry Tuesday, March 26, 2019 5:23 PM
    • Unmarked as answer by jperry Tuesday, March 26, 2019 5:25 PM
    • Marked as answer by jperry Tuesday, March 26, 2019 5:26 PM
    Monday, March 25, 2019 10:16 PM
  • 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

    Tuesday, March 26, 2019 5:38 PM
  • Hi. Glad to hear you got it sorted out. Good luck with your project.
    Tuesday, March 26, 2019 6:08 PM