Graphs show on screen but don't print out

[ptaylor-west]

I have 9 graphs on a form that all work fine and appear on screen but when I print off the last 3 graphs only show the outline.

Please see the screenshot and PDF file attahced to see what I mean.

Any ideas?

 

[M8KWR]

I think it is a printer issue, you may be running out of memory.

Have you tried printing the graphs that do not print, on a seperate report to see if they actually do print? If they do then it will be more then likely a printer problem.

If you have more then one printer in you office etc, then try another one, and see if that works.

Also print the report to acrobat - and then print it - i know it will work then.

I hope this helps.

 

[ptaylor-west]

I tried acrobat as well as a number of printers and still no go.

Messing around with the form I found that if I moved any of the graphs down so they were off screen I had the same problem. So it appears to be that anything which is not visible on screen doesn't print off for some reason.

It has got me baffled as I get the outline boxes to the graphs but not the bars.

My computer is the latest spec with oodles of memory so I don't think it is old technology or anything.

 

[dt01pqt]

Have you got layout for print selected? Have you put any code in the on print and/or on current events? What are you using for the charts Active-X?

 

[ptaylor-west]

Layout for printing is set OK, there is nothing on OnPrint /Curent and the graphs are made using Microsoft Graph which is always a pain to use I know.

Print preview doesn't disply the bars in the boxes either.

 

[ptaylor-west]

Aha, I think I have found it but it doesn't get me round the problem.

If I change the print paper size to A3 everything is displayed, problem is I want to print out to A4... in excel you simply set your print area and it print over as many pages you want but can this be done in Access.

 

[ptaylor-west]

Does anyone have any ideas how I can get round this problem?

 

[dt01pqt]

Does anyone have any ideas how I can get round this problem?

Ok I'm pretty sure it is not a printing problem. Can you tell me what you use to populate the charts? Are you using any events at all?

 

[ptaylor-west]

The charts are taken from queries.

I have experimented in reducing all the boxes/controls etc on the form so that I can see them all on screen and it prints fine, the problem is that it is so small

 

[dt01pqt]

Hmm. Try toggleing with AutoSize on the Chart control. If you are in absolute dispair with ActiveX (MS Chart) there are other solutions that would work just as well.

 

[ptaylor-west]

Thanks I've done all that.

I have decided to split the form in the end which gets me going, not ideal but I think it is just a limitation of MS Graph and we may never get to the bottom of it.

Thanks for all your help, it is appreciated.

 

[Rich]

Forms are not designed to be printed, use a report instead

 

[Crilen007]

Why do people always want to use forms to print and wonder why it doesnt work?

 

[ptaylor-west]

Simply because you can't scroll through a report or change the data in real time to see the changes. you have to run the report each time.

However, I do agree that it is also a pain when it comes to printing out nearly as much as using MSGraph!

 

[dt01pqt]

Sorry I assumed you were using a report. Then again I'm a bit slow I should have looked more carefully.