Form Blinking

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

In MS Access 2000:
When I change forms, the screen blinks while the form
updates. Is there a way to freeze the screen while the
update (queries, refresh,...) are being executed in a
macro? I just split the database, and it got worse.
I connected the front end to a SQL server backend, and it
got even worse.
 
You can use Application.Echo False....and then Application.Echo True. If
you are using macros, Echo.
 
Use Echo False to stop the screen refresh and then Echo True to continue.
You can either use Echo Method of the DoCmd Object or the Application
Object.

A note of caution: Make sure the Echo True statement is executed (using
error-trapping code), even when the code errors out. Otherwise, the screen
will appear frozen. Also beware when you step through the code as well.
 
Back
Top