Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jul 2007
    Location
    North Carolina, USA
    Posts
    71
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Conditional Formatting – Access 2007 Form

    When attempting to use the conditional formatting button; I am limited to 3 different equal to options. I have several list items in the field and would like to group two or three items in the same conditional formatting. (i.e. Expired, Removed, Deleted all have Gray field with black text.)
    I have attempted to use “Expired” Or “Removed and “Expired” And “Removed” but neither option works. Is there a way to use conditional formatting with And\Or statements?

  2. #2
    Lounger
    Join Date
    Feb 2011
    Posts
    43
    Thanks
    0
    Thanked 6 Times in 6 Posts
    You could use
    Expression is [Text2]="A" Or [Text2]="B" Or [Text2]="C"

  3. The Following User Says Thank You to Cronk For This Useful Post:

    swisherink (2012-03-29)

  4. #3
    Star Lounger
    Join Date
    Jul 2007
    Location
    North Carolina, USA
    Posts
    71
    Thanks
    5
    Thanked 0 Times in 0 Posts
    That worked exactly as expected; thank you for helping me figure that out.

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
  •