Problem making controls visible

[Laurel]

I would like to make a couple of controls visible just before I launch into
some lengthy processing. They are a label and a text box that show the
progress of the processing. My problem is that the txtUpdate.Visible = True
doesn't take effect until control is returned to the form.... i.e., after
the lengthy processing is complete.... too late. The .visible = true
command and the processing take place in the clicked event of a button.

Is there a technique I can use to get around this? Some sort of secret
invisible method for returning control to the form and then back to my
processing?

 

[Larry Linson]

Look in VBA Help for DoEvents. That should be what you need. It returns
control to the system so that waiting events can be processed.

Larry Linson
Microsoft Access MVP

 

[Laurel]

Thanks!

Look in VBA Help for DoEvents. That should be what you need. It returns
control to the system so that waiting events can be processed.

Larry Linson
Microsoft Access MVP