I am using Access 2016, and I have a report with a field that has conditional formatting.
The "Edit formatting rule" dialogue box enables me to set Bold, Italic, Underline, Font colour, and Background colour.
The Bold, Italic, Underline, and Font colour settings work, but the Background colour setting does not work. For example, if I select Bold, Italic, Underline, Font colour = red, and Background colour = yellow, then any content that meets the condition is shown with Bold, Italic, Underline, and Font colour = red, but not with Background colour = Yellow. The Background colour appears correctly on the preview in the "Edit formatting rule" dialogue box, but remains white on the actual report (see screenshots below).
Preview in dialogue box:
Result on report:
Is this a bug in Access or is there something else I need to do to make it work?