Refresh a lable control

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

Guest

I am importing a large text file into a talbe. Here are the steps:
- Delete all records in a table
- import CSV file into table (Transfertext )
- update additiona fileds in the table (user id , time stamp ect.)
- normalize the data by copiyind data from one table to many tables.

In this process, instead of using a progress bar, I am updating a lable
control on the form to inform the user of the staus. Some messages are
refreshed on the lable but other are not.

How can I make sure the caption on the label is refreshed before moving to
the step below.

Thanks
Mohan
 
Mohan said:
I am importing a large text file into a talbe. Here are the steps:
- Delete all records in a table
- import CSV file into table (Transfertext )
- update additiona fileds in the table (user id , time stamp ect.)
- normalize the data by copiyind data from one table to many tables.

In this process, instead of using a progress bar, I am updating a lable
control on the form to inform the user of the staus. Some messages are
refreshed on the lable but other are not.

How can I make sure the caption on the label is refreshed before moving to
the step below.
Click to expand...


Make sure? I don't know if you can make sure.

Your best chance is to use Me.Repaint (possibly followed by
DoEvents).
 
You can also write free-text directly to the status bar (rather than a
progress-graph). I use that a lot with good results. The status bar always
gets refreshed.
 
Thanks for the help... me.repaint worked fine.

Marshall Barton said:
Make sure? I don't know if you can make sure.

Your best chance is to use Me.Repaint (possibly followed by
DoEvents).
Click to expand...
 
Back
Top