Slowing down BVA Code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a privert function that display alot of msg boxes. What i have now
done is got rid of the msgboxes and used a text box within a form to display
the text that was on the msg boxes.

The problem is that the code runs too fast and you cant read the text in the
text box. the first text you see is the last bit of text to be displated from
the function.

does anyone know how i can slow down the function
 
My preferred method is to hit the box with a large hammer. Although I'd be
interested to see if anyone has anything better than that.

Though you could go down the dull route and just drop in a few....

for i=1 to whatever
next

bits in there.

Are you sure that you really want to slow things down? Is it really
necessary for the user to see all of your text box messages? Or are you
really talking about just ensuring that messages are visible?
 
StuJol said:
i have a privert function that display alot of msg boxes. What i have
now done is got rid of the msgboxes and used a text box within a form
to display the text that was on the msg boxes.

The problem is that the code runs too fast and you cant read the text
in the text box. the first text you see is the last bit of text to be
displated from the function.

does anyone know how i can slow down the function
Click to expand...

If the function really executes that fast, there seems little reason to
display progress messages. But maybe the problem is that the process is
actually taking a while, but the text on the form doesn't get a chance
to be redisplayed. If that's the case, try putting the statement

DoEvents

into your code after you change the value of the text box. If that
doesn't work, also add a line

Me.Repaint

or

Forms!NameOfYourForm.Repaint

Those changes may give Access a chance to display the changed text.
 
Back
Top