Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2004
    Posts
    2

    Red face Unanswered: Flashing on screen

    Greetings All,
    I have a Access 2000 form that has 10 subforms on 10 tabs in a tab control. I have code (DAO) that checks the the information on the subform and then changes the icon that is displayed on the tab, if the textbox on that tab has data or not.
    The problem is that when the code runs, there is a "flashing" that occurs each time the code is run. Is there a way to turn this flashing off. Everything works fine, it is just that the flashing is distracting to the users.


    TIA

    Bill

  2. #2
    Join Date
    Sep 2003
    Location
    Canada
    Posts
    25
    Wrap your code with this

    Application.ScreenUpdating = False
    Code goes here
    Application.ScreenUpdating = True

    It will look better, and should also perform a bit faster.

  3. #3
    Join Date
    Dec 2004
    Posts
    2
    Brillant! Thanks!

Posting Permissions

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