none
Inconsistent font spacing while exporting access reports to pdf RRS feed

  • Question

  • I am using following VBA code for exporting access report to pdf, sometime this code exports pdf perfectly fine , but sometime spacing between letters is very less. This problem is not consistent and i have not changed any code in between as well. Any thoughts ?

    Code : 

    Sub EXPORT_FILE()

    DoCmd.OpenReport "MyFile", acViewPreview
    DoCmd.OutputTo acOutputReport, "MyFile", acFormatPDF, "C:\XYZ\Directory\MyFile.pdf"

    End Sub  

    TIA

    Thursday, January 11, 2018 4:57 PM

All replies

  • Hello mahi_j,

    I failed to reproduce your issue. Would this issue occur while exporting specific reports or occurs randomly while exporting any reports? If you try to export report manually, would this issue still occur?

    Best Regards,

    Terry


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, January 12, 2018 2:12 AM