Convert Access Report to PDF

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
rowfeiAsked:
Who is Participating?
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
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
 
SimonThompsonCommented:
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
 
GlennHarrisCommented:
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
rowfeiAuthor Commented:
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
 
GlennHarrisCommented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
;-)
0
All Courses

From novice to tech pro — start learning today.