Screen Updating

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.
 
M

Michel Walsh

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top