?
Solved

How do I update a Label Caption in VBA - Access 2007 ?

Posted on 2009-04-20
2
Medium Priority
?
1,392 Views
Last Modified: 2013-11-28
Hi,

I have a program loop where the status is changing and I want to display this information through a Label Caption. This is an object on an Access 2007 form. It updates at the end of my loop but not during. How can I make it update each time I change the value?

Thanks, David.
Example: Me.MyLabel.Caption="The status has just changed from 3 to 4."

Open in new window

0
Comment
Question by:DataTrain
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 200 total points
ID: 24184740
Use

Me.repaint
Doevents

after each change to the label.
0
 

Author Closing Comment

by:DataTrain
ID: 31572239
Thanks - that seams to work.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question