Results 1 to 8 of 8
  1. #1
    4 Star Lounger
    Join Date
    Feb 2008
    Location
    United Kingdom
    Posts
    490
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Flickering Listbox (Access2003)

    I have spent hours trying to find why my listbox flickers in a database. I have finally stripped it down to be able to post it. If an item is selected on the larger listbox, and you click on the button below (which has no code in) the list flickers/repaints or something. If the listbox is used to set the recordsource of a subform, it produces the same problem, sometimes worse than you see now. If someone can confirm they can see this happen, or ideas how I can be rid of this problem I would be very pleased. The db has been converted to Access97 version to get the filesize down. Many thanks
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Flickering Listbox (Access2003)

    I'm using Access 2002 at the moment. If I select an item in List25 (the large list box) and click on the command button, I don't see any flickering. If I select an item (the only item) in List24a, List25 flickers, which is to be expected since its Row Source is changed.

    Select Tools | Options...
    Activate the Forms/Reports tab.
    If the check box "Use Windows Themed Controls on Forms" is ticked, clear it, then click OK.
    Does that make a difference?

  3. #3
    4 Star Lounger
    Join Date
    Feb 2008
    Location
    United Kingdom
    Posts
    490
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Flickering Listbox (Access2003)

    Hi Hans. I tried your suggestion, it was better but still there. The large listbox was on a subform, which was used to set the underlying recordset of the subform. That was much worse for flicker, almost as though the listbox itself was being requeried each time a selection was made. I took the listbox off the subform, and removed the subform, and still had this unstable listbox. Maybe its a peculiarity to Access 2003? I was really hoping it would manifest itself to you. Regards

  4. #4
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Flickering Listbox (Access2003)

    This is a known problem which is peculiar to A2003. From memory, it was due to labels which were not attached to the listbox (why? <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>)
    I believe it was supposed to be fixed by a Service Pack (SP3?)
    It is one of many problems with A2003 (a very flaky version of Access IMHO)
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  5. #5
    4 Star Lounger
    Join Date
    Feb 2008
    Location
    United Kingdom
    Posts
    490
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Flickering Listbox (Access2003)

    Thanks Steve. Yes there is a problem using labels on a tab control, they all flicker when you mouse over them. There is a fix, I know I got over that by using textboxes as labels. Just wish I could sort my listbox out. I have suffered for weeks with it, tried importing bits into a new database, changed the listbox, removed the list from a subform etc. Driving me mad. Regards

  6. #6
    4 Star Lounger
    Join Date
    Feb 2008
    Location
    United Kingdom
    Posts
    490
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Flickering Listbox (Access2003)

    I have managed to add a subform back. Here the listbox flickers when you select a record from the listbox on the subform (Tape Logs) Maybe this will show up the problem. Regards
    Attached Files Attached Files

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Flickering Listbox (Access2003)

    As SteveH noted, this problem is specific to Access 2003. It doesn't occur in Access 2002.

  8. #8
    4 Star Lounger
    Join Date
    Feb 2008
    Location
    United Kingdom
    Posts
    490
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Flickering Listbox (Access2003)

    Thanks Hans. I think Steve is referring to the problems with unbound labels on a tab control. I dont think he meant there is a problem with Access 2003 listboxes themselves, I might be wrong. Regards

Posting Permissions

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