Format based on input

[schwabe]

Hello all,



I'm working on a product list and I would like to add the formatting of a record set in a form, if the product is no more available.

Some more details:
I have a table tabProdcuts and it conatins the following fields:
txtProductName, lnkFunction, logAvailable.

The column logAvailable contains boolean variables with "TRUE" = product available and "FALSE" product not available.

I'd like to color the products red, if the product is not available. In this form, the product is chosen by a combo box.

How do I do that?

Thanks,
Benjamin

[Bob Fitz]

Maybe this could be done with Conditional Formatting

[schwabe]

Hi,

thanks for your reply.
I am not using the field itself for the formatting. So, I guess I will have to do some coding...

Benjamin

[schwabe]

Okay, I just found it, it works with conditional formatting.
However, I'd like to color the whole line in red. How do I do that?

[schwabe]

issue solved, I had to use the same expression for all fields in the form. Thanks