Changing field appearance by anther fields value

[woodyinoz]

Hi all,

I'm looking to change the colour of the text in a field if a field in a linked table has data entered into it.

I have a table on a form which lists all Plates with there ID's which are currently in red. This table is generated from 'Material.DB'. It is linked to 'PartReport.DB' and if a part in this table is allocated a plate id then I want the plate id to change to blue on the form table.

Is this possible and if so, how do I go about achieving this?!

Thanks all,

Woody

 

[reinaldo]

Try the newvalue method


if Part.isBlank()
then
Name.font.color = Red
else Name.Font.color = Blue
endif
endMethod

hope this helps