Solved

Report form to a PDF File in Access

Posted on 2013-06-26
8
386 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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
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
 
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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

830 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