Forms "flicker" on opening

[number2]

I have been unable to determine why several of my forms flicker on opening. It appears as if they quickly open and reopen many time for about 1/2 a second. Any ideas?

 

[JoanneM]

Hi there

possibility -
over use of repaint or sizing
wrong order of code execution - setting focus back and
forth in different forms

Resolution:

Search for instances of the word repaint or requery in
your opening forms.

Check to see if you are loading forms hidden if that is the case space them out so the flicker will be minimised

check your screen resolution ( and your monitor & don't laugh at this check it's position and see if the flicker has an external cause eg a mobile...)

lastly open forms hidden and minimised if you are not using them only returning focus to your startup form when you have done.

if you still have the problem I'll don the thinking cap and work through the process with you


regards


Jo

 

[Brockers]

If you are opening these from Command buttons, try adding an Echo action to the Macro or Code (Event Procedure) for the On Click Event for the Button! The Echo turns the display off while the Macro or Procedure runs and then turns it back on at the end!

For a Macro just insert a row before the OpenForm Action, Put in an Echo Action and set the Action Arguements for Echo On to No

If needed put another Echo in at the end of the Macro after all the Open Forms etc to set the Action Arguements for Echo On to Yes

For Code Insert a line before the OpenForm DoCmd to read:

DoCmd.Echo False

If needed add another line at the end:

DoCmd.Echo True Regards

Brockers
Instructor
New Horizons Manchester England