Solved

Convert Access Report to PDF

Posted on 2009-04-11
6
828 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
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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

One of the questions I get asked again and again is how to validate a field value in an AcroForm with a custom validation script. Adobe provided a lot of infrastructure to do that with just a simple script. Let’s take a look at how to do that wit…
This article is in response to a question here (http://www.experts-exchange.com/Other/URLs/Q_28283850.html) at Experts Exchange. The Original Poster has a scanned signature and wants to make the background transparent so that the signature may be pl…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

895 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

11 Experts available now in Live!

Get 1:1 Help Now