I need to conditionally format something based on another field. If FIELD1 is LIKE a specified value, I want to highlight FIELD2. I run into my problem when I want to highlight FIELD2 when FIELD1 is LIKE one of two specified values.
I've tried two ways at looking at this. The first is to conditionally format the background of FIELD2.
If {InsertRejects9.ForcedError} Like '*|33|*'
Then Silver
Else If {InsertRejects9.ForcedError} Like '*|32|*'
Then Silver
Else White
When I do this, the ELSE statement works, but the IF statements do not.
The other method that I've used is to place a text box with a silver background behind FIELD2, then conditionally suppress it.
If Not({InsertRejects9.ForcedError} Like '*|32|*')
Then True
Else False;
If Not({InsertRejects9.ForcedError} Like '*|33|*')
Then True
Else False;
When I do this, it will only work on the second statement. I've tried using an OR statement, but run into the same problem.
If ((Not({InsertRejects9.ForcedError} Like '*|32|*'))
OR (Not({InsertRejects9.ForcedError} Like '*|33|*')))
Then True
Else False
Does anybody have any ideas on how to make this work?
Thanks!
I've tried two ways at looking at this. The first is to conditionally format the background of FIELD2.
If {InsertRejects9.ForcedError} Like '*|33|*'
Then Silver
Else If {InsertRejects9.ForcedError} Like '*|32|*'
Then Silver
Else White
When I do this, the ELSE statement works, but the IF statements do not.
The other method that I've used is to place a text box with a silver background behind FIELD2, then conditionally suppress it.
If Not({InsertRejects9.ForcedError} Like '*|32|*')
Then True
Else False;
If Not({InsertRejects9.ForcedError} Like '*|33|*')
Then True
Else False;
When I do this, it will only work on the second statement. I've tried using an OR statement, but run into the same problem.
If ((Not({InsertRejects9.ForcedError} Like '*|32|*'))
OR (Not({InsertRejects9.ForcedError} Like '*|33|*')))
Then True
Else False
Does anybody have any ideas on how to make this work?
Thanks!