This is one of my favorite tips, which we first published in August 2007 when conditional formatting was introduced in FileMaker Pro 9. A not-uncommon request we’ve received over the years is to highlight the current field with something more than slightly darker field borders. Conditional formatting seems the perfect answer: there must be a way to change a field’s background fill from its default to another color on entering the field, right? Turns out… no. You cannot use conditional formatting to change a field’s fill color on entering it. It’s just not possible. Never. Conditional formatting does not work in any way whatsoever while focus is in the field in question.
The Support Group
Recent Posts
Tuesday, February 9, 2010, Chad Novotny presented Finding and Sorting Your Data, a webinar hosted by FileMaker, Inc. You can download the video (which requires the WebEx WRF Player), as well as the sample FileMaker file used in the presentation. This file is best used with FileMaker Pro 10 or later. Not all aspects of the file will work in earlier versions of FileMaker Pro. We hope you find this webinar informative and useful.
