Posts

Showing posts from March, 2011

Export MS Access report to Excel..Font Problem

I was working on a small assignment on access and trying to export an Access report to Excel. Everything worked when until i opened the exported Excel, to my surprise font colour of all the lines in the excel was very light. I tried to change the field color, font weight and all possible properties, nothing seems to be working. But finally i got the solution. The trick was 1. Make the back style of the the fields to "Transparent" which was default "Normal" 2. Make the Fore Color as Automatic black from the eclipse next to the property. Spent few hours trying to make things work so sharing it for the people. Happy Coding, Parshuram