[AccessD] Jumping Screen Fix - now I know how but not why

This is for Excel, but it may point you on the right path at least Rocky...

<< http://www.cpearson.com/excel/VBE.aspx>>



-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Wednesday, 23 May 2012 2:04 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Jumping Screen Fix - now I know how but not why

 
Dear List:
 
As you know I have been struggling with the problem of the 'jumping screen'
in a 2003 mde when a form opens. 
 
After trying many things to analyze the problem and fix it,  I finally hit upon adding DoEvents in the Resize event of every form, and that appears to have solved the problem.  
 
So that's the how to fix it, but why I don't know.  I'm just curious - does anyone have any insights?
 
So the fix is in on version 23.  Unfortunately I am now working on version
24 so I have to insert DoEvents into all of the forms - and there a lot of them.  Does anyone have a snippet of code that would insert the event in every form?  Or a site where I might find such a piece of code?
 
MTIA
 
Rocky Smolin
Beach Access Software
858-259-4334
www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com <http://www.e-z-mrp.com/>
Skype: rocky.smolin