MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Updating text in form while routine is running

  Asked By: Boell    Date: Oct 24    Category: MS Office    Views: 1545

I have been using the status bar to indicate status while routines are
running but would prefer to use a form for this purpose. However, if I
try to update the text in a form while code is running, the text
doesn't show, only the title of the form shows. Anyone know a trick to
make the text show?



1 Answer Found

Answer #1    Answered By: Sonya Flores     Answered On: Oct 24

Try putting a form  refresh and or a doevents after you've written the text.

Instead of the status  bar have you tried writing to the immediate window?

OTOH.. You may want users to see what's happening. What control or part of
control are you using for the text?

FWIW I sometimes use a listbox on a form. It works well for me and is
scrollable so I can see a history of what happened.

Didn't find what you were looking for? Find more on Updating text in form while routine is running Or get search suggestion and latest updates.