Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Order of process .Visible (97 SR2)

    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 ?

  2. #2
    dave_hill
    Guest

    Re: Order of process .Visible (97 SR2)

    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.

  3. #3
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Order of process .Visible (97 SR2)

    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>

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Order of process .Visible (97 SR2)

    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.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •