none
DoCmd.OutputTo to pdf or XPS format does not print images or OLE objects from Report footer, but does from Report body RRS feed

  • Question

  • Hi all,

    I have an Access 2010 report that is not exporting footer images or OLE objects to pdf or XPS format, while when the controls containing them are copied and pasted to the main body of the report, they show up fine. The images contain signatures that I need to have on every page. Is there a setting that is preventing this? Or is the Report corrupted? If I copy the image containers to a new report with nothing else on it, the images show up fine in both places.

    The command I'm using is:

                DoCmd.OutputTo acOutputReport, stDocName, acFormatPDF, stPath, -1
     

    Rob

    Sunday, March 8, 2020 2:26 AM

Answers

  • Thanks, Tom. Yes, it works for me on a new report also, in Access 2010. The odd thing is, if I open the report with:

    DoCmd.OpenReport stDocName

    it opens in OneNote, and the images are there in the footer as they should be.

    I did try copying all my report objects to a new report, but it behaved the same way as the original, which makes me think that the original report is not corrupted.

    Another oddity is that I have a label time-stamp in the footer, which shows up fine in the pdf export.

    I did find that if I move the image-containing objects (I have tried both OLEbound container and an image frame) to the header, it does show up when exported as a pdf. So what I have done, as a work-around, is to move the objects to the header, since pdf is a desirable export choice.

    Rob
    • Marked as answer by RobH18 Tuesday, March 10, 2020 2:42 PM
    Tuesday, March 10, 2020 2:40 PM

All replies

  • Images in the footer work just fine for me. I am using A365 but I see no reason it wouldn't work for A2010 either.

    -Tom. Microsoft Access MVP

    Sunday, March 8, 2020 4:46 AM
  • Make sure the Footer Visible property on the report is set to Yes.
    Sunday, March 8, 2020 2:46 PM
  • Thanks, Tom. Yes, it works for me on a new report also, in Access 2010. The odd thing is, if I open the report with:

    DoCmd.OpenReport stDocName

    it opens in OneNote, and the images are there in the footer as they should be.

    I did try copying all my report objects to a new report, but it behaved the same way as the original, which makes me think that the original report is not corrupted.

    Another oddity is that I have a label time-stamp in the footer, which shows up fine in the pdf export.

    I did find that if I move the image-containing objects (I have tried both OLEbound container and an image frame) to the header, it does show up when exported as a pdf. So what I have done, as a work-around, is to move the objects to the header, since pdf is a desirable export choice.

    Rob
    • Marked as answer by RobH18 Tuesday, March 10, 2020 2:42 PM
    Tuesday, March 10, 2020 2:40 PM
  • Thanks Lawrence. Yes, the Footer Visible property is set to Yes. Also, see my reply to Tom.
    Tuesday, March 10, 2020 2:42 PM