Results 1 to 2 of 2
  1. #1
    Harley Guy is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2010
    Posts
    57

    Conditional Formatting for Reports


    I have a report that I would like to have a field highlight when data is present...or when the field is not blank.

    I have found numerous fixes to hightlight a field when it is null or blank...is there a way to do the reverese?

    Thanks in advance!

  2. #2
    Harley Guy is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2010
    Posts
    57
    OK, I kept playing around and found the solution. Go to condtional formatting, select new rule and use Field Value Is Not Equal To "blank"...then select the color you wish to use to highlight the field...this will hightlight the field when information is present.

    Thanks!

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

Similar Threads

  1. Conditional Formatting
    By riaarora in forum Access
    Replies: 2
    Last Post: 08-12-2012, 02:09 AM
  2. Conditional formatting on reports
    By JenEveAle in forum Reports
    Replies: 2
    Last Post: 12-20-2011, 10:53 PM
  3. Conditional Formatting
    By Paul H in forum Reports
    Replies: 3
    Last Post: 11-07-2011, 11:59 AM
  4. Conditional Formatting
    By cevatyildiz in forum Forms
    Replies: 8
    Last Post: 04-30-2010, 12:01 PM
  5. Conditional formatting
    By ylivne in forum Reports
    Replies: 1
    Last Post: 07-12-2009, 06:18 PM

Tags for this Thread

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