Results 1 to 2 of 2

Slow Conditional Formatting in Datasheet View

  1. #1
    EddieN1 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011

    Slow Conditional Formatting in Datasheet View

    We're having a bit of a performance issue and I'm trying to improve it. I have forms that show in datasheet view and several of the fields have conditional formatting in them. (Many of these simply provide a background color that applies to all rows. I haven't found any other way to set the background on a cell in datasheet view except to use Conditional Formatting.) Whenever I move from one row to another, ALL the Conditional Formatting is cleared for all rows and columns, then they get re-applied. In addition to it being very annoying (it's like a flickering screen), it appears to slow down the cursor movement from one row to another. Any ideas how I can improve the appearance and performance of this?

    Thanks, Eddie

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    I experience the same issue on a very small db. Don't think it is fixable. It is what it is.
    How to attach file: To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 6
    Last Post: 11-21-2012, 05:10 PM
  2. Replies: 16
    Last Post: 09-12-2012, 08:39 AM
  3. Formatting a number field for datasheet view
    By RamiMohaisen in forum Access
    Replies: 3
    Last Post: 02-08-2012, 05:46 PM
  4. COnditional Formatting on a Datasheet
    By anoob in forum Access
    Replies: 2
    Last Post: 02-28-2011, 12:48 AM
  5. Replies: 5
    Last Post: 12-06-2010, 09:29 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
Tech Forums: Microsoft Office Forums