Solved

Access 2016 Chart/Graph Sizing issue

Posted on 2016-09-07
12
29 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
  • 7
  • 3
  • 2
12 Comments
 
LVL 34

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
 
LVL 34

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
Integrate social media with email signatures

Is your company active on social media? Do you also use email signatures? Including social media icons in your email signature is a great way to get fans for free. Let all your email users know you’re on social media quickly and easily, in a single click.

 

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 34

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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Follow this checklist to learn more about the 15 things you should never include in an email signature from personal quotes, animated gifs and out-of-date marketing content.
Scam emails are a huge burden for many businesses. Spotting one is not always easy. Follow our tips to identify if an email you receive is a scam.
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

705 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now