Here is one that has come up at my work and I haven't been able so far to resolve.
We have a report that has a group header and detail section. The BackColor of the detail section is the default white, while the group header is only slightly off-white ( a faint touch of grey) just enough to visibly differentiate the two.
When the user exports the report to Excel, one column that in the report had its ForeColor set to blue, comes out in not just a light grey, but a dark grey, and the text is there but invisible.
To make it show up, the user has to manually change the cell style to "Normal". Also, when the user selects the entire column, the text is faintly visible.
Anyone seen this before and have any idea how to fix it? I have never run into this before.
Edit: Forgot to mention, same effect in both Access 2000 and 2010.