Results 1 to 7 of 7
  1. #1
    hikerdood is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Mar 2016
    Posts
    44

    Report Conditional Formatiing

    I created a report from a cross tab query and want to conditional format a field based on another fields data.


    The report has the field [KO CL CD] which can be "K" or "O" and [%Exp] which is a percentage. The "K" indicates that the Job Order is closed with "O" indicating that the Job Order is open. I am trying to format the field [%Exp] yellow if the percentage is between 80% and 90% and the field [KO CL CD] ="O". I tried the below expression in conditional formatting and had no luck.

    ([%Exp] between 0.8 and 0.9) and [KO CL CD] ="O")

    Appreciate any help

    Regards

    Hikerdood








  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    I presume you had an error - remove the last )

    note that using non alphanumeric characters in your field names can cause misleading errors

  3. #3
    hikerdood is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Mar 2016
    Posts
    44
    Thanks Ajax. Worked perfectly and I changed the field name to all alpha.

    Hikerdood

  4. #4
    Kirnicko is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    8
    Am new to this forum, so I apologize if I'm doing this wrong. I am desperately trying to figure out how to do conditional formatting if a text field CONTAINS certain words? i.e. If the word "brakes" is in the field somewhere, highlight entire field a certain color. The conditional formatting rules seem so specific and I cannot figure out how to have keywords searched and then highlight the whole field if found.-kirnicko

  5. #5
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    welcome to the forum - your question is unrelated to this thread so recommend you start your own thread. When you do, provide more information - searching and conditional formatting are unrelated. Also provide some information about where the word 'brakes' is generated - from a table? a control on a form?

    asumming it is a control called txtSearch and the field you want to conditionally form is called txtField

    your conditional formatting would be
    Expression is: [txtField] Like "*" & [txtSearch] & "*" And [txtSearch]<>""

  6. #6
    Kirnicko is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    8
    Have spent too much time trying to figure out how to create a new thread. My links are shaded out. I will just respond to this in hopes you can help.

    I have a vehicle database. One field is "Issue" on the table. This field is "unlimited" text field. To describe "brakes checked" or "a/c not working". Whatever the issue on a car is. In my REPORT I have a conditional format to search for "brakes" and another for "oil change" and various others. These highlight different colors so we can see patterns on the report. Its working at the moment, but I cannot add any other conditional formats (it just doesn't respond). I cannot find anywhere detailed information to do this, only very specific "if/then" conditional i.e.if over 10,000 or if text= "Bill". In a report that goes on several pages, I need to see where different items show up. Also, I don't know why my keyboard is struggling with this site, I'm only getting every other letter so its taking forever to type. Please respond. and thank you for your first response

  7. #7
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    go to this link

    https://www.accessforums.net/forumdisplay.php?f=7

    and click on the 'post new thread' button near top left of the screen

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

Similar Threads

  1. VBA Form to Report Conditional
    By M.Enders in forum Programming
    Replies: 2
    Last Post: 11-26-2018, 06:17 PM
  2. Conditional Report Details
    By M.Enders in forum Reports
    Replies: 7
    Last Post: 08-15-2018, 02:06 PM
  3. report conditional formating
    By Arroyo in forum Reports
    Replies: 3
    Last Post: 10-17-2017, 12:22 AM
  4. Send Email on Click Decimal Formatiing
    By Lewis825 in forum Access
    Replies: 1
    Last Post: 05-10-2016, 06:44 AM
  5. Conditional Value in report design?
    By ieatglitter in forum Reports
    Replies: 2
    Last Post: 11-30-2014, 02:37 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