Michael,
Just another thought - in this situation I generally use a textbox which is formatted to LOOK like a label. This way the Refresh method is easily used. I wonder if this would work for you in this situation?
I realize you have a couple of good answers elsewhere in the thread, but I thought I'd throw this out too.
Barbara
>Hi All,
>
>I have a modal form I am using to build some files and display the results to the users. The processing is broken down into a number of methods. Before each method is called I assign a new value to a label field on the form and refresh the screen thereby telling the user what is going on. This all works fine except when the method executes a SQL statement. Then the label is not refreshed until after the method has executed. Here is the code:
>
>ThisForm.lbl1.caption = "Running some SQL."
>ThisForm.refresh
>ThisForm.RunSomeSQL
>
>The label caption is not refreshed until after the RunSomeSQL method has completed. Let me repeat that the above code works when the method does not execute a SQL statement. This is too wierd to me.
>
>Thanks