Solved

Convert Access Report to PDF

Posted on 2009-04-11
6
833 Views
Last Modified: 2013-11-28
Is anyone know why when I convert the Access report to PDF format by using Adobe Acrobat Pro 9, all the color of the texts becomes black in the PDF file?

How can I keep the all colors of access report into PDF format?

THanks
0
Comment
Question by:rowfei
[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
6 Comments
 
LVL 3

Expert Comment

by:SimonThompson
ID: 24124967
I assume using the snapshot format is not viable, we have had lots of trouble sending access reports and snapshoot is by far the best
0
 
LVL 12

Expert Comment

by:GlennHarris
ID: 24125575
This depends on the method used to create the pdf and the settings in distiller;
Assuming Access 2003, don't choose print > pdf, use the acrobat menu>convert to pdf command; If that still leaves the text black (assuming it is colored differently), then select the acrobat menu > conversion settings command. Then click the advanced settings, then pick the color folder on the left side. For color management select Leave Color Unchanged. Additiionally, it wouldn't hurt if you installed a color-capable PostScript printer like a tektonix or kodak and point it to 'file' not 'lpt1'
0
 

Author Comment

by:rowfei
ID: 24126059
I have changed Leave Color Unchanged under color management. But if I use acrobat menu> conversion, the color is missing. However, if I use print>PDF, the color is stay. Any ideas why this happend?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 12

Expert Comment

by:GlennHarris
ID: 24126179
The conversion command opens up the distiller preferences; one of those profiles (high quality/press quality/smallest file size, etc.) is set default to b&w, hard to say which w/out seeing your computer.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 24126293
rowfei,

Do you *Have* to use Adobe Acrobat Pro 9?
I use this, which is very popular with Access developers.
It keeps the colors in the reports with no problems whatsoever.
Code from:
http://www.lebans.com/reporttopdf.htm

Here is a sample database as well.

;-)

JeffCoachman
Access-BasicSelectOneSingleRepor.mdb
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24221647
;-)
0

Featured Post

Get HTML5 Certified

Want to be a web developer? You'll need to know HTML. Prepare for HTML5 certification by enrolling in July's Course of the Month! It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
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 this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

632 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