Order of process .Visible (97 SR2)

[Brian Swann]

This has got to be simple, but .... I've created an Unbound Text box on a form, txtCalculating = "Calculating, Please Wait ....", and Visible = NO. In the OnClick event of a command button I simply have:

Me.txtCalculating.Visible = True
' Do some Calculations here
.
.
.My calculations are complete and now
Me.txtCalculating.Visible=False

The text never appeared to be visible, so, I removed the Visible=False and lo and behold, after the calculation is completed - bingo the text becomes visible. In other words the .Visible command is processed after the calculations. Whassup ?

[dave_hill]

Timing, Brian. Everything is timing.
You have to tell it to Repaint the form (Me.Repaint) so the textbox will appear and vanish as you wish.

[Brian Swann]

Thank you Dave <img src=/S/bow.gif border=0 alt=bow width=15 height=15> Works just fine.
But ya know, I wouldn't have thought of that since after the calculation I make other fields .Visible without needing to repaint, but never mind ... here have another bow <img src=/S/bow.gif border=0 alt=bow width=15 height=15>

[MarkLiquorman]

You have to remember that Access doesn't always wait for each process to complete before it moves on to the next one. Certain tasks get passed on to be completed when time allows (such as screen updates). You essentially "beat the machine" by changing the visible property before the next cycle time.