Results 1 to 3 of 3
  1. #1
    MatthewGrace is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Jan 2013
    Posts
    159

    Conditional Formatting in Datasheet View

    I've notice that in Datasheet view, Conditional Formatting seems to have a subtle flaw: it forces a background color change that interrupts the natural flow of "Alternating Row Color". See attached pic and notice how the alt row color is greyish, but the Conditionally Formatted cells (they have red text) forces a White background which, over the course of a large datasheet, makes it ugly.



    Any way around this or should I live with it? I've checked for a transparent BG color but couldn't find it. I also went into design view and set the Back Style as Transparent and played with options a bit to no avail.

    Ty for any thoughts
    Matt
    Click image for larger version. 

Name:	conditional formatting fail.jpg 
Views:	10 
Size:	27.1 KB 
ID:	18572

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    I don't think they can be made to work together. My solution was to set Conditional Formatting on every control so the entire row shows the same back color, instead of changing font color. This means no alternate row shading at all.
    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.

  3. #3
    MatthewGrace is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Jan 2013
    Posts
    159
    Very creative as always June, thanks.

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

Similar Threads

  1. Replies: 1
    Last Post: 04-30-2014, 05:26 PM
  2. Replies: 8
    Last Post: 01-10-2014, 12:38 PM
  3. Replies: 1
    Last Post: 04-24-2013, 08:51 PM
  4. Formatting a number field for datasheet view
    By RamiMohaisen in forum Access
    Replies: 3
    Last Post: 02-08-2012, 05:46 PM
  5. COnditional Formatting on a Datasheet
    By anoob in forum Access
    Replies: 2
    Last Post: 02-28-2011, 12:48 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