Results 1 to 4 of 4
  1. #1
    Big G is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2016
    Posts
    2

    Is There a Way to Filter a Report by Color

    I have a MS Access 2010 report that contains a column (fields) of Next Due Dates that are conditionally formatted. When a Next Due Date is within 60 days of the due date, the background color for the field turns yellow. If the date has come and gone (late), the background color for the field turns red. I would like to know if there is an easy way to filter the report so that only yellow and/or red colored items show in the report and all other items (items that are up-to-date) will not show in the report. There doesn't seen to be a way to filter the report by color like you can do in Excel.



    Any help with this problem is greatly appreciated. Thanks very much!

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Not that I am aware of. Would need to set a filter on the same values used for the conditional formatting.

  3. #3
    Big G is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2016
    Posts
    2

    Post a reply to the thread: Is There a Way to Filter a Report by Color

    Quote Originally Posted by ssanfu View Post
    Not that I am aware of. Would need to set a filter on the same values used for the conditional formatting.

    Thanks very much for the feedback. Sounds complicated. Think I'll look for a different, simpler approach. Thanks again.

  4. #4
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Sounds complicated. Think I'll look for a different, simpler approach.
    Not complicated. You already have the criteria for the conditional formatting. Take that same criteria and apply it to the report query or the filter property.


    Good luck with your project.

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

Similar Threads

  1. Report Background Color using VBA
    By baba in forum Reports
    Replies: 2
    Last Post: 06-21-2015, 07:26 PM
  2. Change Color of Box on Report based off Value
    By Nuke1096 in forum Access
    Replies: 10
    Last Post: 01-29-2014, 02:47 PM
  3. Replies: 2
    Last Post: 01-28-2013, 05:12 PM
  4. Export Report as jpeg (in color)
    By Kupot in forum Reports
    Replies: 1
    Last Post: 05-28-2009, 08:13 PM
  5. Replies: 0
    Last Post: 10-24-2008, 11:20 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