Change the color of a row in a form if criteria is met

[Mac1206]

Can anyone tell me how I can change the color of row data in my form if it meets this criteria and how would I create the query if it already has a select statement that populates the form...

* Distribution Type: In-Service Withdrawal
* Disbursement Amount: $50,000.00 or more
* Disbursement Method: ACH Transfer

 

[welshgasman]

You could apply the same expression to all controls in the row using conditional formatting ?
Or use Crystal's method.

https://www.youtube.com/watch?v=2ArtsDJrK7k

 

[Mac1206]

You could apply the same expression to all controls in the row using conditional formatting ?
Or use Crystal's method.

https://www.youtube.com/watch?v=2ArtsDJrK7k

So, I can apply all 3 criteria's within the expression in conditional formatting and if so, how would I write the expression in order to meet the 3 criteria's:


If any row meets this criteria:
* Distribution Type: In-Service Withdrawal
* Disbursement Amount: $50,000.00 or more
* Disbursement Method: ACH Transfer
Then highlight those specific rows....

 

[welshgasman]

It depends on how many controls you have to whether you do it individually or use Crystal's method.? Up to 5 I'd probably do them individually, any more I'd put in the extra control and do it Crystal's way. The expression would be the same either way?

You build the expression just the same as if you did it in VBA but without the If and with []

[Amount] > 50000 AND .......