Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-31-2018, 01:51 AM
mark99k's Avatar
mark99k mark99k is offline Userform dimensions suddenly exaggerated Windows 7 32bit Userform dimensions suddenly exaggerated Office 2010 32bit
Novice
Userform dimensions suddenly exaggerated
 
Join Date: Oct 2012
Location: California USA
Posts: 20
mark99k is on a distinguished road
Default Userform dimensions suddenly exaggerated

This is the weirdest behavior I've ever seen in >15 years of VBA. All of the userforms in my largest Word add-in suddenly now display at vastly more than their intended width and with a varying amount of extra height.



All controls are proportionally elongated horizontally, but not vertically. (So there's a chunk of extra dead space at the bottom of the form, but none on the side.)

The extreme width ranges from double to quintuple the design width, and is visible both in the VBE and when the form is run. But the added height (which is not nearly as extreme, typically an inch or so) is seen only when the form is run.

Adjusting a form's width explicitly in the Activate event (Me.Width = xxx) restores normal proportions to all controls no matter what width is specified. That is, I can get normal appearance by adding Width and Height specs and then fudging the intended dimensions by trial & error. Clearly that's not a fix. (This add-in has over 30 userforms.)

The screenshots attached illustrate. Sorry for the resizing, but the original dimensions of the uncorrected one would make the post's window a scrolling nightmare. Notice the shape of the buttons on right in the ridiculous image vs. the nonridiculous images. The actual displayed width of the former is more than 4x that of the latter.

This happens on various PCs with different video card and monitor setups, so obviously it's not a hardware thing. Where do I even start?

Grateful for any clues.
Mark
Attached Images
File Type: jpg ss1.jpg (17.5 KB, 28 views)
File Type: jpg ss2.jpg (44.0 KB, 28 views)
Reply With Quote
 

Tags
userform



Similar Threads
Thread Thread Starter Forum Replies Last Post
True 4:3 background dimensions a_gunslinger PowerPoint 1 11-28-2016 08:22 PM
Userform dimensions suddenly exaggerated Drawing room layouts with dimensions Jeff Fenerty Drawing and Graphics 4 01-01-2016 07:13 PM
VBA Code in a UserForm module to delete a Command Button which opens the userform Simoninparis Word VBA 2 09-21-2014 03:50 AM
Command button to show userform suddenly stopped working jpb103 Word VBA 0 05-22-2014 06:05 AM
Userform dimensions suddenly exaggerated Page dimensions are changing in word 2003 OldFashionedOutlookUser Word 4 05-15-2012 02:44 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:41 PM.


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