Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Access 2016 Chart/Graph Sizing issue

Posted on 2016-09-07
12
Medium Priority
?
700 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 40

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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 40

Assisted Solution

by:PatHartman
PatHartman earned 2000 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 40

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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

New style of hardware planning for Microsoft Exchange server.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

971 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