[AccessD] Access Charts (Graphing) and resolution issue

MartyConnelly martyconnelly at shaw.ca
Tue Nov 30 11:41:00 CST 2004


Here is one explanation, maybe hunt around their site for further info.
They do a lot of Access printer work.

There is a bit of a bug in Graph, that runs something like this:

If you create a graph in a report where your screen resolution is say
1024x768  and then move that report with a graph in it to a machine running
800x600, the internal OLE object for the Graph, doesn't resize and your
graph appears to run out side of the OLE control.  I'm assuming that's what
you are seeing when trying to play with the zoom etc.

The only way to work around this is to design your graphs at a modest
resolution and make sure that the internal chart area inside the graph
object itself (not the ole control on the page, but the chart area) has
sufficient room around it so that if the graph container "shrinks" on page
resolution, that its still fully visible.

This impacts printing (i.e. the visible resolution of the screen), due to
WYSIWYG (haven't heard that term in a while) interplay between the screen
resolutions and printer output in drawing.
-- 
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg


Lavsa, Rich wrote:

>I had checked that before and all are set to (small fonts) Normal Size
>or 96 DPI depending on the Windows version XP or 2000.  Either way all
>are set to 96DPI.  
>
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
>Sent: Tuesday, November 30, 2004 10:51 AM
>To: 'Access Developers discussion and problem solving'
>Subject: RE: [AccessD] Access Charts (Graphing) and resolution issue
>
>
>Rich,
>
>A possibility is that the DPI setting on your screen resolution might be
>different between PC's.  Go to Settings, push Advanced, and see what
>your setting is and your customer's setting.  Changing DPI will affect
>the resolution of the entire screen.
>
>Dan Waters
>ProMation Systems
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lavsa, Rich
>Sent: Tuesday, November 30, 2004 9:10 AM
>To: Access Developers discussion and problem solving
>Subject: [AccessD] Access Charts (Graphing) and resolution issue
>
>Hello all,
>
>I have an issue.  I spent hours getting my graphs to work properly on
>these reports.  I seem to have hit yet another snag with the chart
>object.  I have my resolution set to 1024 x 768 and my users are usually
>on 800 x 600.  I take into account when developing to make sure the
>screens fit on a 800 x 600 screen.  I didn't do testing on my graphs
>using a standard users computer because I didn't even think this would
>be an issue.  What is happening is that the graphs are getting chopped
>off at the Right hand side on a users machine where they are not on my
>machine.  
>
>Just to test my theory that it had to be the resolution I reduced mine,
>and it happened to me as well.  I am certain it has to do with the
>resolution set on each machine.  
>
>Has anyone ever encountered this, or have any idea on how to overcome
>it.  The graphs are somewhat complex in the fashion that I have to
>populate temp tables because the aggregation will not happen all at once
>in a query, and most of the graphs are trend style over a month or even
>yearly so they are usually wide.  
>
>Thanks in advance
>Rich
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada






More information about the AccessD mailing list