Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-08-2020, 04:33 PM
kjc kjc is offline Option buttons are distorted on some PCs Windows 10 Option buttons are distorted on some PCs Office 2019
Novice
Option buttons are distorted on some PCs
 
Join Date: May 2020
Posts: 12
kjc is on a distinguished road
Default Option buttons are distorted on some PCs

Recently, a spreadsheet has started displaying distorted controls on some PCs.
See the attachment for a picture of what is happening. They look fine when I create them. Any ideas on how to solve this? Thanks.
Attached Images
File Type: jpg distorted controls.jpg (76.3 KB, 8 views)
Reply With Quote
  #2  
Old 05-08-2020, 06:28 PM
macropod's Avatar
macropod macropod is online now Option buttons are distorted on some PCs Windows 7 64bit Option buttons are distorted on some PCs Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,358
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

That is most likely a display driver issue. Try downloading & installing the latest display drivers for the PCs concerned.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 05-09-2020, 02:24 PM
kjc kjc is offline Option buttons are distorted on some PCs Windows 10 Option buttons are distorted on some PCs Office 2019
Novice
Option buttons are distorted on some PCs
 
Join Date: May 2020
Posts: 12
kjc is on a distinguished road
Default

Thanks for the response, macropod.

I've checked that the drivers are the latest and Windows is up to date. (unless there is something I don't understand about how to do this.)

Now it is acting up on my machine. I'm working on a Windows 10 64-bit SurfacePro 7 with an LG 34" WQHD widescreen attached via HDMI cable. I created the workbook with the LG screen as the working screen and the SurfacePro screen off. If I used extended displays or turn off the LG and turn on the SurfacePro screen only, the same issue occurs.

I've read online (vba - Excel: the Incredible Shrinking and Expanding Controls - Stack Overflow) where others have this issue and have solved it by setting the control height and width on worksheet activation using shp.height = shp.height and shp.width = shp.width, and it seems to "undistort" the option buttons, but for some reason, it also moves them to a different location. It completely resizes buttons and dropdowns as well as moves them. It also moves checkboxes.

Does the additional info give you any other ideas?
Reply With Quote
Reply

Tags
distorted controls, form controls

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Option buttons are distorted on some PCs Falling at the last hurdle with Checkboxes and Option buttons kiwimtnbkr Excel Programming 14 06-11-2019 10:03 AM
Option Buttons - linking and control natelfo Visio 2 04-18-2018 09:40 AM
Option buttons for multiple choice questions ScottishPolarBear Word 4 12-02-2014 02:23 PM
Display cells dependent on option buttons inq80 Excel 0 09-01-2014 03:40 PM
Option buttons are distorted on some PCs Word 2007 Option buttons - transparency JacobThomas Word VBA 1 11-02-2011 05:40 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 01:23 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft