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

Comments

RLBoston said…
Me too! Thank you!
2:06 AM
ABC said…
thanks
7:33 PM
Amy Poe said…
This has been driving me crazy for a while. Thanks so much, your solution worked perfectly.

Thanks!
10:52 PM
Parshuram said…
Happy to help
4:07 PM
Otto DIEDERICKS said…
Thank you Parshuram! (I had the "Transparent" setting right. Played around with the Font COlor but to no avail!)
9:05 PM
Unknown said…
Thanks - 11 years later!
9:13 PM
Unknown said…
yup, still applicable and just as welcome today as it was in the past.
1:46 AM
Ed said…
Man - I cant say thank you enough.
6:00 AM
Post a Comment

Popular posts from this blog

6000 KM Road Trip

Image
Embarking on a road trip had always been our goal since we acquired our first car back in 2009. However, between demanding work schedules and challenging road conditions, the idea remained a distant dream. It wasn't until 2023 that circumstances shifted, granting us the freedom to prioritize exploration over work commitments. In January 2023, we finally indulged in a short but exhilarating road trip across Karnataka, spanning over 2000 kilometers. Despite the distance, the experiences we encountered along the way were nothing short of extraordinary. Inspired by our memorable journey, we resolved to delve deeper into the rich tapestry of India's cultural and historical treasures. Our itinerary took shape, beginning with the awe-inspiring Ajantha and Ellora caves in Aurangabad, then venturing to the sacred sites of Puri and Konark along the eastern coast. From there, our route traced a path southward through Andhra Pradesh and Tamil Nadu, culminating at the southernmost tip
Read more

Testing AWS Rekognition from POSTMAN

Image
I was trying AWS Rekognition & before using it in the app, i wanted to test with POSTMAN. But unfortunately there are not many resources available to be useful. Thus showing the simple way to setup POSTMAN. Obviously before jumping to POSTMAN, we need to have an AWS account setup and a user been created. (The user should have Rekognition related permissions) Also make sure to note the Access Key & Secret Key.  Lets start the POSTMAN & create a new POST request. The url to hit is  https://rekognition.ap-south-1.amazonaws.com  . It could change depending on your selected AWS region, mine is ap-south-1. First thing to set is the Authorization & select "AWS Signature" from the Type. Enter AccessKey, SecretKey which we noted while creating the new user. AWS Region should be from url & Service Name is "rekognition". We need to add 2 extra headers, "Content-Type" as "application/x-amz-jon-1.1" & "X-Amz-
Read more