Results 1 to 5 of 5
  1. #1
    Thomasso is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Nov 2016
    Location
    Czech Republic
    Posts
    250

    Report not displaying installed font correctly

    Hello,



    I installed a 3rd party font to use with my MS Access reports. Specifically "Open Sans" available here: https://fonts.google.com/specimen/Open+Sans

    The font is installed correctly as far as I know, I can work with it inside Access without any issues. I use it in all the forms and reports. Also when I print a report on my paper printer, the font is displayed correctly.

    The problem appears when I try to export the report to PDF:

    Code:
    DoCmd.OutputTo acOutputReport, strReportName, acFormatPDF, strDestination
    (strReportName and strDestination are variable that I pass to the function)

    The font is changed for "Courier". When I try to print with "Adobe PDF", the print fails and says "missing font". However I double checked that the font is installed.

    Any ideas what might be causing this issue?
    Thank you.

    Tomas

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    Is it a TRUE TYPE font?
    if you dbl-click it in c:\windows\fonts, it will display correctly?
    does the font show correctly in Report Design?

  3. #3
    Thomasso is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Nov 2016
    Location
    Czech Republic
    Posts
    250
    Quote Originally Posted by ranman256 View Post
    Is it a TRUE TYPE font?
    if you dbl-click it in c:\windows\fonts, it will display correctly?
    does the font show correctly in Report Design?
    The font shows correctly everywhere (report design, report preview, printed on paper.....). Everywhere except PDF exported file.

    Yes it also opens up correctly in c:\windows\fonts.

    Not sure how to tell if it's a true type font.

  4. #4
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    Perhaps you need to add the font to adobe (no idea how as I don’t use it)

  5. #5
    Thomasso is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Nov 2016
    Location
    Czech Republic
    Posts
    250
    Quote Originally Posted by CJ_London View Post
    Perhaps you need to add the font to adobe (no idea how as I don’t use it)
    That was my assumption as well, but it doesn't work in Windows native PDF either. I tried:
    • DoCmd.OutputTo acOutputReport, strReportName, acFormatPDF, strDestination (native Windows PDF)
    • Open Report > Print > Adobe PDF


    However, if I do Open Report > Print > My actual laser printer, then the font works correctly on the paper.

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

Similar Threads

  1. Replies: 5
    Last Post: 07-01-2020, 08:18 AM
  2. Join Not Displaying Correctly
    By spyldbrat in forum Access
    Replies: 22
    Last Post: 08-16-2018, 03:39 PM
  3. Forms not displaying correctly on monitor 2
    By Perceptus in forum Forms
    Replies: 2
    Last Post: 11-06-2014, 01:45 PM
  4. Replies: 8
    Last Post: 12-09-2013, 09:31 AM
  5. Displaying Queries Correctly
    By cgjames in forum Reports
    Replies: 0
    Last Post: 01-18-2011, 06:54 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