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!!