Solved

Convert Access Report to PDF

Posted on 2009-04-11
6
832 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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
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.
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…

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