Solved

Access 2016 Chart/Graph Sizing issue

Posted on 2016-09-07
12
273 Views
Last Modified: 2016-11-17
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
Comment
Question by:DAY 3
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 3
  • 2
12 Comments
 
LVL 37

Expert Comment

by:PatHartman
ID: 41788601
Since the graph is displaying, I would say it is the graphics card.
0
 

Author Comment

by:DAY 3
ID: 41788620
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
 

Author Comment

by:DAY 3
ID: 41788655
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 37

Assisted Solution

by:PatHartman
PatHartman earned 500 total points
ID: 41788689
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
 

Author Comment

by:DAY 3
ID: 41788853
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
 

Author Comment

by:DAY 3
ID: 41792213
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
 

Accepted Solution

by:
DAY 3 earned 0 total points
ID: 41832735
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
 
LVL 37

Expert Comment

by:PatHartman
ID: 41832752
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
 

Author Closing Comment

by:DAY 3
ID: 41838059
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
 

Expert Comment

by:Steve Sayko
ID: 41889820
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
 

Expert Comment

by:Steve Sayko
ID: 41891536
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
 

Author Comment

by:DAY 3
ID: 41891751
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

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question