• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1178
  • Last Modified:

Access 2016 Chart/Graph Sizing issue

I am migrating an established Access 2010 database to a new computer and to Office365 Access.  The new computer is the 64bit Core i7 Surface Pro 4.  I have numerous Graphs in this database which all refuse to display larger than 1/4 their frame size.  I am currently unable to try this database on any other machine which is also running the latest Office365 Access, so I'm not sure if it is the graphics card or the new Access version.
With a right click in the graph design view, I have tried everything I can think of with "Chart Object"/ Edit.Graph Size is A Quarter of Frame Size
0
DAY 3
Asked:
DAY 3
  • 7
  • 3
  • 2
2 Solutions
 
PatHartmanCommented:
Since the graph is displaying, I would say it is the graphics card.
0
 
DAY 3Author Commented:
Thanks Pat for helping to confirm my suspicion about graphics card.  So now, what is a solution to this problem, without affecting the chart performance on other computers?  This database will eventually be used on multiple devices; laptops and tablets like this Surface.
The Charts will not only be dynamically generated in the Forms, but also in Reports and converted to PDF.
0
 
DAY 3Author Commented:
So if this Microsoft computer can’t properly display the basic graphs developed with Microsoft software… is there a different hardware question section of Experts here?  I would be very grateful to solve this problem somehow.
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
PatHartmanCommented:
Does Excel have the same problem?  If not, you might have to embed Excel Graphs on your Access forms and reports.  I don't have a surface pro so I can't test the theory.
0
 
DAY 3Author Commented:
Excel graphs work perfectly within Excel.
I have resisted using embedded Excel in these forms, because the forms are already burdened with Tab Controls and many other controls on each Tab.  In the past, I had bad experiences in previous Access versions with embedded Excel. Hopefully this version will cooperate and play nice for me.  I will get a chance later on to experiment and then report back.
0
 
DAY 3Author Commented:
I started the process of embedding an Excel chart in one of my forms to replace the simple access graph.  Other than a recalc flicker, I think it would work.  But I have a dozen of these graphs, 5 of which are within tabs on one form.  I resent having to further burden these forms with Excel when I know Access works perfectly already.... except for on this machine.
I spent 3 hours on the phone talking with 4 different tech experts at Microsoft; two of which remoted into my machine and were amazed with my problem.  They accused me of having a complex application, so I downloaded one of their generic Northwind databases and put a simple graph on a form to show them the exact same problem.... which only occurs on my machine.
So after doing diagnostics on my machine and current updates, they confirmed that they don't see anything wrong.  They were supposed to get additional tech people to contact me today, but I haven't heard back yet.
I will continue to update my progress.
0
 
DAY 3Author Commented:
Thank you Pat for offering assistance on this.
After numerous visits with Microsoft Tech support who remotely logged into my computer to experience my problem, I also visited an expertly staffed Microsoft store to demonstrate the issue, but mostly to demonstrate on other Surface Pro 4’s.  When every machine we looked at had the same problem under similar circumstances, it was easy to conclude that the Surface Pro 4 has a bug.
I also found out that setting my docking station to only display on the remote monitor, I can design with proper graph scaling on that screen.  Until MS comes out with a firmware patch for the Surface, I can live with this compromise.  There are very few circumstances where resolution is misrepresented.
0
 
PatHartmanCommented:
I'm sorry it wasn't something they could fix for you.  Perhaps, they will figure out the problem and someday it will be resolved.  At least you have something you can work with in the mean time.
0
 
DAY 3Author Commented:
I don't want to mislead anyone doing a search that there was a solution to this problem.  There was no solution to the problem, but I discovered an acceptable way of working around it.
The solution that Pat Hartman suggested is also a work-around that I have used for other reasons in other projects, but it wouldn't be acceptable here.
0
 
Steve SaykoCommented:
Regarding the resizing of Access Charts that began in late 2016, I am having the same problem with graphs resizing.   Resizing occurs on multiple computers and in the PDF print out.  These are reports that have been functioning perfectly for years on many different computers and printers.  I rely on generating 100s of pages of graphs directly from Access.  The last post on this topic was October 11, 2016.  Has there been any progress since then?
0
 
Steve SaykoCommented:
I have checked the 3 computers in my office with Office 365, two have the chart resizing problem, one is OK.  
  PROBLEM - HP Laptop Windows 10 Pro 64-bit / Office Update 16.0.6965.2092
  PROBLEM - DELL Laptop Windows 10 Pro 64-bit / Office Update 16.0.6965.2105
  WORKING - DELL Desktop Windows 10 Pro 32-bit / Office Update 16.0.6965.2105
It's a small sample but the 32-bit Windows works, the 64-bit Windows fail.
0
 
DAY 3Author Commented:
Hi Steve, my Surface and Office 10 has updated twice since this problem was posted, but the sizing issue still persists.

Surface Pro 4 i7 with 64-bit Windows 10

I have used the machine substantially more in the past few months, and my resizing issue still seems to be limited to some video’s (usually pre-video promotions) and with all graphs within MS Access.  I do a good bit of PDF generation within Access, and I haven’t seen any PDF sizing issues.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 7
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now