Results 1 to 4 of 4
  1. #1
    Arroyo's Avatar
    Arroyo is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Sep 2017
    Posts
    9

    report conditional formating

    Hello
    Is it possible to put more values in into 1 condition, for example if field value is equal to "Bob", "Bill, and " Brandon" then apply selected format ?

  2. #2
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    You have fields with more than one value in any record? Or does the field contain csv type data? If it's the former, I wouldn't know since I and many others avoid MVF's like the plague.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    Arroyo's Avatar
    Arroyo is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Sep 2017
    Posts
    9
    actually i want to format fields in report depending on a value of one of them. i succeed to do that with conditional formatting but cant repeat it, didn't save. don't know whats wrong. all fields are from the same query, same table.

  4. #4
    Arroyo's Avatar
    Arroyo is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Sep 2017
    Posts
    9
    i got it...needed to change from "field value is" to "expression is" to work

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

Similar Threads

  1. Conditional Formating
    By Derrick T. Davidson in forum Forms
    Replies: 5
    Last Post: 04-13-2013, 07:18 AM
  2. Conditional formating in a report
    By msmithtlh in forum Programming
    Replies: 12
    Last Post: 03-20-2013, 02:25 PM
  3. Conditional Formating
    By redbull in forum Reports
    Replies: 2
    Last Post: 03-26-2012, 12:08 PM
  4. Conditional Formating (Report Field)
    By mlawson6128 in forum Programming
    Replies: 1
    Last Post: 03-10-2011, 11:23 PM
  5. Conditional Formating In A Report
    By cadsvc in forum Reports
    Replies: 11
    Last Post: 11-02-2010, 04:47 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