When I export my report to excel, the column headings are in a black font while data rows are a very light grey. My actual report shows the font to be black. How/where do I fix the font color? I know it's hard to see with the image attached...
Novice
Windows 7 32bit 
Access 2010 32bit
When I export my report to excel, the column headings are in a black font while data rows are a very light grey. My actual report shows the font to be black. How/where do I fix the font color? I know it's hard to see with the image attached...
Expert
Windows 7 64bit Access 2010 32bit
How are you exporting the data to Excel?
If you are using the built-in DoCmd.TransferSpreadsheet method, you cannot control formatting. You will have to use VBA Automation to create custom formatting like that.
Novice
Windows 8 Access 2013 64bit
change to fore color of the fields to text1.
remove Lighter 25%
Default Font for Export to Excel
Posting Permissions
Reply With Quote