Delayed Visible on VBA code

[cejeff06]

Hello!

I am writing a VBA event procedure in MS 2007 Access for when you click a button. My code is quite lengthy and I want some labels I created to become visible as the code finishes certain sections so the user will know it is running correctly. When the form opens these labels are invisible (.visible=False), and throughout the code, at specific points, I've inserted lines that turn each of these labels visible (.visible=True).

The code works because they all turn visible, but they ALL turn visible at the same time at the END of the VBA procedure! This defeats the purpose of letting the user know that the code is running!

I'm sure there is a line of code that can make these labels visible in real time- and not wait until the end of the procedure. If anyone can help I would GREATLY appreciate it!!

Thanks so much!!

 

[WayneRyan]

ce,

Try putting:

DoEvents

as a line in your code.

Wayne

 

[pbaldy]

Personally I use SysCmd to put updates in the Status Bar, but you can try adding

DoEvents( )

in your code to see the label changes, but it can noticeably slow down processes.

 

[pbaldy]

Darned slow fingers!

 

[cejeff06]

Thank you both! That did EXACTLY what I was looking for!