Return to FileMaker.com
Conditional formatting with empty field
Hi FileMaker experts,
I am imposing conditional formatting on a set of fields for data entry checking.
entry1 ≠ entry2 -- fill with color.
Entry1 is entered as 0 and Entry2 is blank, which is different; however, FileMaker do not flag this difference. How can I flag (fill the color) this?
Isempty ( entry2 ) will be true only if the field is empty
you might also try:
getastext ( entry1 ) ≠ GetasText ( entry2 )
Retrieving data ...