disable screen updating

[Lynn]

I perform a number of operations on a form - and as I do
that, the screen flickers slightly. I would like to freeze
the screen while I do my operations, and then refresh when
I am done.

How is that done?

 

[Brian]

I perform a number of operations on a form - and as I do
that, the screen flickers slightly. I would like to freeze
the screen while I do my operations, and then refresh when
I am done.

How is that done?

Before you begin your operations, issue the following statement:

Application.Echo False

Then, when you are finished:

Application.Echo True

Also a good idea to issue the "True" statement in an error handler for the
procedure, in case something goes wrong.

 

[StCyrM]

Good evening

Take a look at the Echo command in Help

Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.