Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi

    I'm using conditional formatting on a report.
    One of the fields: [Why] contains a phrase e.g "Rework:Wheel Damaged" or "Reworkoor dented".
    Using " Expression Is ", what would be the syntax to highlite on the report where the phrase contains "Rework" ?

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    If Rework is always the first word you can use:
    Left([Why],6)="Rework"

    If Rework is anywhere within [Why]
    [Why] Like "*" & "Rework" & "*"

  3. #3
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you, it works great.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •