Screen updating off
You can use a form's Painting property to disable updates to that form, but some activities still seem to show through or cause flashing on the screen. Sometimes you need more control over screen repainting than you get with either Form. a string indicating text to be displayed within the status bar while screen updating is disabled. This sample form simply opens three reports in design mode and then closes them.
You can also optionally pass the method a second parameter?
The acb Show Updates method really doesn't do much besides what a direct call to Application.If the handle is 0, Windows reenables screen updates to the locked window.Because the only window you care about locking in Access is the main Access window itself, the In Access 2.0, finding the window handle (the unique integer that identifies every window) for the main Access window was difficult.To make sure that your application doesn't show the properties sheet while it does its work, you can retrieve this property, set the first character to 0, and then save it.The code might look like this: The only way this will have any influence is if you call this code before you've loaded any reports in design mode.