Refresh Processing Status

[Guest]

What is the best way to display the processing status on a form on a text box
in the form. I can get this to work, only if the process is not too intense.
If it is intense, it won't display until the processing is done. I want it
to display first, not last.

ie
'Set the Message
Form!txtMessage = "Updating the Rows"
Form!txtMessage.refresh or Form!txtMessage.requery ??? Doesn't Work well.

'Run the Process
Run_Sub_Update_Rows

Thanks

Ross

 

[Marshall Barton]

What is the best way to display the processing status on a form on a text box
in the form. I can get this to work, only if the process is not too intense.
If it is intense, it won't display until the processing is done. I want it
to display first, not last.

ie
'Set the Message
Form!txtMessage = "Updating the Rows"
Form!txtMessage.refresh or Form!txtMessage.requery ??? Doesn't Work well.

'Run the Process
Run_Sub_Update_Rows

Try using Form!txtMessage.Repaint

If that's not suffucuent, add a DoEvents statement before
you start the process.