Results 1 to 8 of 8
  1. #1
    Miles R is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Mar 2019
    Posts
    263

    Alternating colours of continuous form go wrong

    I have a continuous form with alternating colours of Blue and Light blue.
    Sometimes when scrolling through the form, the colours go wrong - see attached.
    When I go past and back up again, they get reset correctly. Possibly a refresh after scrolling would clear it?
    Anyone seen this before, is it an Access bug or a graphics card issue or something like that?



    Click image for larger version. 

Name:	Capture.JPG 
Views:	24 
Size:	25.3 KB 
ID:	47432

  2. #2
    Micron is offline Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,372
    Never seen it before - assume it's a graphics card/driver or Windows issue. You should not have to repaint the form, but that's an option I guess. I would not think it mattered if you used theme or standard colours for those choices, or a mix of those colours either. The 6 or 7 blocks that alternate across are null fields?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,646
    I have seen it but can't remember cause. It was a long time ago.

    If you want to provide db for analysis, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    Micron is offline Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,372
    This contains 2 possible causes

    https://www.accessforums.net/showthread.php?t=16679
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  5. #5
    Miles R is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Mar 2019
    Posts
    263
    Thanks for the replies.
    Don't think this is anything to do with the design. It's a simple continuous form without any conditional formatting. The blocks of the wrong colour are where there is no text box on the form.

    It only happens when dragging the scroll bar fast and the blocks are cleared when moving past them.

    Doing a screen refresh does not clear them.

    I guess I will have to live with this. Never had or noticed this problem in Access 2007. Might remove the alternate shading altogether or possibly adding some dummy fields to the form.

  6. #6
    Miles R is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Mar 2019
    Posts
    263
    I have found two workarounds for this problem.
    1. Create a disabled and locked transparent text box the full width and height of the detail section, at the back. This seems to completely stop the blocking from appearing.
    2. Set the two background colours the same. Also works, but lose the advantage of identifying the lines easily.

    Not sure which I will use yet. Don't really like using the cludge of option 1.

  7. #7
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,283
    Why not post enough so other members can see if it happens to the DB on their computer.
    I only have 2007, but others here will have later versions.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  8. #8
    Miles R is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Mar 2019
    Posts
    263
    Nice idea, but it would take too much effort - would probably have to copy most of the database to do it.
    Got to move on as I have already spent several hours on this.
    My solution is just to remove the alternate colours.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 06-30-2020, 12:35 PM
  2. Different Colours if Record is true
    By bishmedia in forum Reports
    Replies: 3
    Last Post: 06-08-2018, 02:10 PM
  3. colours in query
    By emcloa in forum Programming
    Replies: 7
    Last Post: 10-15-2012, 08:09 AM
  4. Replies: 1
    Last Post: 11-02-2011, 03:15 AM
  5. Reports and Colours
    By BarbT in forum Access
    Replies: 2
    Last Post: 10-08-2011, 07:47 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums