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 Blog
FileMaker Pro 11 introduces three new functions: Get(AccountPrivilegeSetName), Get(AccountExtendedPrivileges), and Get(QuickFindText). Get(QuickFindText) obviously returns the contents of the Quick Find field in the status toolbar; its main use will be in scripts for custom menus that override the default Quick Find behavior. But those first two… didn’t we already have Get(PrivilegeSetName) and Get(ExtendedPrivileges)? Those are still there as well, renamed as Get(CurrentPrivilegeSetName) and Get(CurrentExtendedPrivileges).