ScreenUpdating

[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

 

[Wayne Morgan]

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]

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.

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

Shame VBA is so different across MS apps.