Title
Make all empty fields a certain color
Post
Hi,
I have a database where I would like to make all my fields yellow when they are empty, and when I enter a value, I'd like the field to go back to white. Specifically, this is on one layout of the database. I'm currently trying to build a mobile version of my database that I use on an iPod Touch.
Is there a way to do this for every field in my database?
The idea is to be able to easily spot an empty field by having it be a bright color, and when it is filled in, it would go back to having a white background.
FileMaker Pro Advanced 12
Hi Rob,
In layout mode, select the fields and choose Conditional… from the Format menu.
Add the formula: IsEmpty(self)
Set the fill colour to yellow.