Flickering Forms. 3

[Neoduder]

Hi All,

I have designed a database using forms as a user interface. To make everything look neat I have removed all the toolbars at the top of the screen and also have a macro which maximises each form on 'Open' and 'Activate'. Unfortunately this has had the side-effect of making all the forms flicker when opening. It looks like the form initially takes the original size (When the toolbars did exist) and then flickers as it resizes to the maximum screen size. Does anybody have any ideas how I can get rid of this annoying effect. Thanx in advance.

Chris

 

[930driver]

You can turn echo off at the beginning of the macro and turn it back on at the end. This will prevent repaints during the resize.

HOWEVER, I wouldn't recommend doing this in a macro. There is no error handling in macros. In the event of an unhandled error with echo off your app will appear to freeze. I'd suggest you do this in vba where you can incorporate a proper error handler. In the error handler you turn echo back on to avoid a potential 'freeze'. "The Key, The Whole Key, and Nothing But The Key, So Help Me Codd!"

 

[Neoduder]

Smashing. Cheers.

 

[WildHare]

Another trick you might try is to open the form in HIDDEN mode first, then MAXIMIZE it, and then "un-hidden" it (me.visible=true). That way, the form is already maxed out when it opens.

e.g.,

~~~~~~~~~~~~~~~~~~~~~~
Docmd.OpenForm &quot;xxxx&quot;, , , acHidden (<-- I THINK it's fourth arg, not sure)

Docmd.Maximize
Forms!xxxx.Visible = True

~~~~~~~~~~~~~~~~~~~~~

or words to that effect.

Jim Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm