Form.Repaint does not work while in a loop
Posted on 2005-05-10
Form.Repaint to update a label while a procedure is running works just fine when the code runs from top to botomb without any kind of loops.
But once I loop through a recordset and try to updatre a label for each iteration by using the Form.Repaint at the end of each loop nothing happens.
Even worse is that the form label does not get updated even after the procedure is finished but rather I have to set the focus off the form to see the label update through all its previously set caption values 1 after the other.
I am trying to implement some kind of basic progress indicator but how can I make this work in access 97?