Conditional formatting (easy one)

[matey56]

Hi,


I want to format an unbound box based on the value of another field. I know how to write the expression [Other_Field] = "Text" However, I want to format the box if there's any value at all in the other field. How do I write that?

[pbaldy]

Nz([Other_Field], "") <> ""

[ranman256]

try expression =: Not IsNull([Other_field])

[Welshgasman]

Could also check the length

[matey56]

Thanks all, they both work.