Solved

Report form to a PDF File in Access

Posted on 2013-06-26
8
400 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
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.

 
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

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Looking for advice on how to develop a project database 2 48
Create a varying recordset 5 54
SCOM - Service Restart 1 30
Access 2003 query, remove dupes 17 26
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
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.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

752 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