Solved

Report form to a PDF File in Access

Posted on 2013-06-26
8
353 Views
Last Modified: 2013-06-29
I have a report that my boss request in a PDF format.


When it is in the PDF format the first page looks fine but the second page has a dark back ground showing. How do I stop that from happening. Why does that happen?
Stats.pdf
0
Comment
Question by:gigifarrow
8 Comments
 
LVL 4

Expert Comment

by:LCCSAM
ID: 39279337
What is the format of the report to begin with?
What are you using to convert this report?

You could save that one as a .jpg and manually lighten it, but it would be easier to alter it from the source material.

Are you using adobe acrobat or reader?
0
 

Author Comment

by:gigifarrow
ID: 39279372
Thanks for your time

I am using adobe acrobat.


I dont understand what you meant about the format. It is a report in access. Now If this helps they are all text fields with code in it.

I need to be able to have my users use this button. I cant have them changing it to a jpg and then lighten it. I had this issue before and all i had to do was change something in the settings in the report. I cant remeber what I did.
0
 
LVL 4

Expert Comment

by:LCCSAM
ID: 39279412
Highlight the darkened areas in design view. Change the "Back Color" property (Format Tab) to #ffffff

This should change the cell color to white.Property sheet
0
 
LVL 31

Expert Comment

by:Helen_Feddema
ID: 39279450
It might be an alternate row color, for higher versions of Access.

Alternate Back Color
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 21
ID: 39279454
It would help to know the version of Access and the version of Adobe Acrobat.

In the report settings check the alternating background color.
0
 

Author Comment

by:gigifarrow
ID: 39279571
Sorry I am using ACCESS 2010 and ACROBAT XI

I tried changing the backgrounds to white and that didnt work. If you notice It is the whole page 2 nothing happened to page 1
0
 
LVL 4

Accepted Solution

by:
LCCSAM earned 215 total points
ID: 39279686
Make sure that both the Background and alternate background are #ffffff in the Headers, Footers, and details sections.

(I've had Background1 be a different color for each of these fields)
0
 

Author Comment

by:gigifarrow
ID: 39286681
Thanks for taking the time export to give your time to help. I found out the problem the Detail has a alternate background color and it was not Background 1. I change it to that and not all of the backgrounds are now white
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now