Turn screen updating off

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

alexhatzisavas - 28 Jul 2005 09:14 GMT

Hi all.

In Access VBA, what is the equivalent of Excel's VBA statement:
Application.ScreenUpdating = False ?

In Excel, this statement disables the flickering of the screen while the
application is working.

In Access, i'm running some queries via a CommandButton on a Form, and i
would like to lose the flickering of the screen while the queries are being
executed.

Thank you,
Alex

Reply to this Message

Allen Browne - 28 Jul 2005 09:30 GMT

In Access:
DoCmd.Echo false

Be sure to turn it back on again (e.g. after the error recovery) or your
working blind.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> In Access VBA, what is the equivalent of Excel's VBA statement:
> Application.ScreenUpdating = False ?
[quoted text clipped - 9 lines]
> Thank you,
> Alex

Reply to this Message

David C. Holley - 28 Jul 2005 13:07 GMT

Try DoCmd.Echo False/True

> Hi all.
>
[quoted text clipped - 10 lines]
> Thank you,
> Alex

Reply to this Message