Hi all,

I have a fairly simple database where I need to change the colour of a layout item based whether or not the expiry date is less than today's date. Basically the layout is designed like a simple card and I just want to turn the card red if the it's expired and needs renewing. So my question is, is it possible to change the colour of layout items (a simple rectangular box in this case) based on this calculation. I have no problem with setting up the script for this, I'm just not sure whether I can change the colour of a layout item based on it.

Many thanks for any help

Cheers

Kevin

Use conditional formatting on the "card" (your expiry date field) with a calc something like:

Expiry date < Get(CurrentDate)

and with the colour red as the result

is it possible to change the colour of layout items (a simple rectangular box in this case) based on this calculation.

Some layout objects - not all - can be formatted conditionally. A rectangle is not one of these, but you can use a text object (with only a space as the text) instead.

Buttons are great for conditional formatting, this way you dont need any dummy fields - they can even have rounded corners

Only minus is a minimum height of 5 px, ( font size = 1 )