Results 1 to 4 of 4
  1. #1
    cebrower is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Spring Lake, MI
    Posts
    110

    Font size changes when using OutPutTo method

    I use the following to create a report that I can then attach to an email that gets sent using VBA:

    DoCmd.OutputTo acOutputReport, "rptDelDetails", acFormatPDF, "e:\DeliveryDetails" & varInvoiceNumber & ".pdf"

    This worked fine until recently when suddenly the point size of the text changed from about 12 to something like 30. This report looks fine when sent to a printer. Any suggestions?

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    the PDF 'printer' may not have the same fonts (& sizes) as other printers.
    so it substitutes.

  3. #3
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Only suggestion I can think of is to make sure this isn't a screen resolution issue or that the pdf view isn't zoomed because you didn't say if it's only the font or the whole view that's larger. That would explain the OK result when printed.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    cebrower is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Spring Lake, MI
    Posts
    110
    raman256 got me to thinking. This report was created by a user who ls logged in via terminal server. Looks like the PDF 'printer' is not redirected. Thanks for the help.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 12
    Last Post: 01-12-2019, 06:02 PM
  2. Anyway to increase font size
    By GraeagleBill in forum Access
    Replies: 1
    Last Post: 04-16-2018, 09:35 PM
  3. Msgbox font size
    By GraeagleBill in forum Access
    Replies: 7
    Last Post: 02-05-2018, 02:50 PM
  4. UI Font Size
    By bertsirkin in forum Access
    Replies: 4
    Last Post: 06-23-2017, 07:24 PM
  5. MsgBox font size
    By GraeagleBill in forum Programming
    Replies: 4
    Last Post: 01-02-2013, 02:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums