modeSetup and clear the "delineate" check box. When this check box is selected (and I find it truly irritating that this is the default setting for new layouts), field formatting such as the fill color is only applied to the active record.
Phil - thanks for the tip! I had no idea what "delineate" meant! Who would ever know this? I agree with your comment that this is "truly irritating." I wish the HELP system was much better, but nothing in the field 'display state' help box refers to this. We are all left guessing.
I finally found the HELP article on this under the title, "Showing field borders and fill for the current record" ... which is the exact opposite of what I wanted to do. The path for this (for others who stumble upon this post with the same problem) is this:
Home > Designing and creating databases > Creating and managing layouts and reports > Editing layouts > Showing field borders and fill for the current record