Results 1 to 4 of 4
  1. #1
    f15avionics is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Sep 2012
    Posts
    2

    Date Conditional Formatting

    I have set a conditional format for a report...very basic, Now()+7 and set it to format to turn red, but it will not turn red unless I click on it. Any help?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    What view are you using? I've never had a problem with CF in preview or report views.

    Interesting user name; my son-in-law is an F-15E Strike Eagle pilot. My daughter is a maintenance officer on them.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    Make sure the control BackStyle property is set to Normal, not Transparent.
    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
    f15avionics is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Sep 2012
    Posts
    2
    Sorry, It was in the reports. June7 that was exactly it. The setting was on transparent.

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

Similar Threads

  1. Conditional Formatting
    By riaarora in forum Access
    Replies: 6
    Last Post: 09-03-2012, 05:58 AM
  2. Conditional formatting
    By avarusbrightfyre in forum Forms
    Replies: 3
    Last Post: 07-01-2011, 11:18 AM
  3. Conditional Formatting date due color
    By Desstro in forum Programming
    Replies: 1
    Last Post: 12-08-2010, 11:12 PM
  4. Conditional Formatting
    By pkstormy in forum Code Repository
    Replies: 0
    Last Post: 08-30-2010, 09:31 PM
  5. Conditional Formatting
    By DanOzDirect in forum Reports
    Replies: 3
    Last Post: 07-21-2010, 08:49 PM

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