Me.Repaint Doesn't Update Screen
Posted on 2004-10-06
I have an Access application which takes a long time to perform all of its functions. I would like to work with other applications while I'm waiting for the work to complete.
I have a text box which is updated as key tasks are completed. After I update the text box, I do a Me.Repaint (and even a Me.Refresh) to show the updated text.
However, as soon as I change the focus from my Access application to another application (such as Excel or Outlook) the Access application no longer updates. I just freezes until the entire application is complete.
Is there a way to keep the Access screen updating even when it loses focus?