Me.Repaint Doesn't Update Screen

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?
LVL 2
dastrwAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
shanesuebsahakarnConnect With a Mentor Commented:
Try DoEvents instead.
0
 
dastrwAuthor Commented:
For 500 points could you be a little more specific like giving me a DoEvents example?

Thanks.
0
 
shanesuebsahakarnCommented:
That's literally all there is to it - just replace Me.Repaint with DoEvents, and that should kick it into action.
0
 
dastrwAuthor Commented:
Thanks.  I thought I might have to invoke, poll for, and trap events.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.