ScreenUpdating

  • Thread starter Thread starter Damien McBain
  • Start date Start date
D

Damien McBain

in excel I go...
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
 
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.
 
Wayne said:
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.
Click to expand...

Thanks Wayne, it would have taken me a week to guess that!

Shame VBA is so different across MS apps.
 
Back
Top