Results 1 to 10 of 10
  1. #1
    irish634 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Feb 2012
    Posts
    48

    Reports: Chart plot area not printing from database

    Hi Everyone,

    I have a frustrating thing going on.
    I have reports that display a chart. The chart and data display correctly. The chart and data output to pdf correctly.

    However, if I print to ANY printer (other than print to pdf) from within the database, my chart plot area does not print. The axis labels and such print, but the plot area with the data will not print. If I print the pdf, everything prints correctly.



    Does anyone have an idea to point me in the right direction? I have attached a couple of pics to show what I am talking about.

    Incorrect print. Sent to printer from the database:
    Click image for larger version. 

Name:	Incorrect.JPG 
Views:	23 
Size:	48.0 KB 
ID:	39825

    Correct display and correct print when printed from PDF
    Click image for larger version. 

Name:	Correct.JPG 
Views:	23 
Size:	60.3 KB 
ID:	39824

    Thanks!

  2. #2
    isladogs's Avatar
    isladogs is offline Access MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,204
    Check the Display When property for the chart. Options are: Always / Print only / screen only
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

  3. #3
    irish634 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Feb 2012
    Posts
    48
    Quote Originally Posted by isladogs View Post
    Check the Display When property for the chart. Options are: Always / Print only / screen only
    That was the first thing I thought. But it is set to "Always." But even so, when it's set to screen only the entire chart doesn't print, meaning border, axis, and everything. In this case, the plot area is the only thing not printing....

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    If you want to provide db for analysis, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    irish634 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Feb 2012
    Posts
    48
    I'll have to spend some time cleaning the db out. It's quite entailed at this point.... Might be later this weekend.

    Everything I have found online points to the entire object not printing or updating. In this particular case, it is just the plot area. The rest of the chart object prints fine. This happens when printing to 2 printers and a copier at work, so doubtful it's a printer/driver issue.

    Weird part is, it only happens on printing directly to the printer. It shows fine in print preview; prints correctly in print to PDF (external printers), output to PDF through Access, etc. The printers print the PDF file fine. So far, it's just when printing from the database in print preview mode.

    I will have to try it on another PC at work and see if it still happens. I also have to try printing it from report view instead of print preview.

  6. #6
    isladogs's Avatar
    isladogs is offline Access MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,204
    While you are testing, try decompiling which will remove any corrupt code you may have
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

  7. #7
    irish634 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Feb 2012
    Posts
    48
    Quote Originally Posted by isladogs View Post
    While you are testing, try decompiling which will remove any corrupt code you may have
    I do that religiously, but will do it then as well.

  8. #8
    isladogs's Avatar
    isladogs is offline Access MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,204
    Just checking that you realised I said decompiling not compiling.
    http://www.fmsinc.com/microsoftacces.../Decompile.asp
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

  9. #9
    irish634 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Feb 2012
    Posts
    48
    Quote Originally Posted by isladogs View Post
    Just checking that you realised I said decompiling not compiling.
    http://www.fmsinc.com/microsoftacces.../Decompile.asp
    Yep. I always do that after major changes and/or long coding sessions.

  10. #10
    irish634 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Feb 2012
    Posts
    48
    I just wanted to update:
    This appears to be confined to a Win 10 PC and not particularly an Access issue. If I print from my work laptop (Win7), everything prints as it should. I'll update further if I come up with a solution.

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

Similar Threads

  1. printing records into fixed area on a report
    By cfljanet in forum Reports
    Replies: 8
    Last Post: 11-22-2017, 03:29 PM
  2. Replies: 13
    Last Post: 09-29-2017, 11:53 AM
  3. Replies: 9
    Last Post: 05-09-2017, 08:57 AM
  4. Replies: 8
    Last Post: 09-24-2014, 05:36 PM
  5. Multiple Plot Pivot Chart
    By Catch Wrestler in forum Reports
    Replies: 0
    Last Post: 06-21-2010, 10:17 AM

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