ScreenUpdating

message from Damien McBain on 26 May 2004
Application.ScreenUpdating = False
...before running an "ugly" subroutine (one that makes the screen change a
lot).

How do I do this in Access?

TIA

Damo
 
Wayne Morgan replied to Damien McBain on 25 May 2004
DoCmd.Echo False
or
Application.Echo False

Remember to include turning it back on in your error handler as well as the
normal location in your code in case you wind up there instead of where you
should be.
 
Damien McBain replied to Wayne Morgan on 27 May 2004
Thanks Wayne, it would have taken me a week to guess that!

Shame VBA is so different across MS apps.
 

Archived message: ScreenUpdating (MS Access Database)