Screen Updating

  • Thread starter Thread starter Michael Stevens
  • Start date Start date
M

Michael Stevens

Hi,

In excel I often use 'screenupdating = false' to suppress screen flickering
while a macro is running. Is there an equivalent in Access??

Cheers
Mike.
 
Hi,


You have the choice in using Application.Echo (see help file), but I think there can still be
some flickering. Another solution is to use the API LockWindowUpdate... but locking the update of
a window is always a potential problem: if the user sees no activity, he/she may think your
application is frozen, and decide to reboot the PC. At least, ALWAYS use error handling to get
back into an unfrozen mode...

Private Declare Function LockWindowUpdate Lib "user32" Alias "LockWindowUpdate" (ByVal hwndLock As
Long) As Long


Use:
LockWindowUpdate 0 'to unfreeze

LockWindowUpdate Application.hWndAccessApp ' to freeze Access window update



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top