Problem with label caption changes not showing...

[YoungPhoenix09]

Hey everyone!

Hope everyone's day is going well so far. I have an issue with one of my labels not changing when the caption property is updated. I'm using VBA to code a button that runs a few queries and generates a report after the results have been created. I'm trying to update a label's caption to display status messages inbetween when queries are ran using the database.execute command, but the code is processing too fast for the changes to appear in the form when they are supposed to.

The compiler actually starts running the query before the caption's change appears in the form, which causes some messages not to display at all. What's weird is that I have a progress bar on the form and it gets updated, but the label's caption is not. Any suggestions??

Thanks!!

 

[ypma]

I may be missing the point . Could you not execute the lable name change in the event on click of the command button and then enter your code for the query and reports in the event after update of the commnand button .

 

[YoungPhoenix09]

Not exactly... The queries take a good while to run sometimes so I want the label to change captions as a status update as to what process is being run so the user can have a sense of what's going on. Therefore, the whole code is executed with the click event of the command button.

 

[Galaxiom]

Try the DoEvents command. Another one would be the Repaint Method of the form.

 

[YoungPhoenix09]

The Repaint method worked perfectly! Thanks!