Jim Lawrence
accessd at shaw.ca
Sat Jul 24 16:09:46 CDT 2010
Hi Stuart: Thanks for the tip...I just ran into a mental block. I did finally solve the problem by adding the following line after setting the PDFCreator object but before running the print report command: Application.Printer.ColorMode = acPRCMColor ...and that seems to solve the problem. Thanks again Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Saturday, July 24, 2010 12:20 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] PDFCreator with Access File, Page Setup, Page - Use a specific printer. In the selection box, select PDFCreator, click on Properties and select Black and White. -- Stuart On 24 Jul 2010 at 11:58, Jim Lawrence wrote: > Hi Stuart: > > I did not know that Access reports could be set to black & white? > Where is this setting made? > > TIA > Jim > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart > McLachlan Sent: Saturday, July 24, 2010 11:25 AM To: Access Developers > discussion and problem solving Subject: Re: [AccessD] PDFCreator with > Access > > My first guess would be that the sub-report was formatted to print > in B&W and that is overriding the settings for the main report (since > it is the first part built by Access.) > > > -- > Stuart > > > On 24 Jul 2010 at 11:08, Jim Lawrence wrote: > > > Hi All: > > > > I have been using PDFCreator extensively with MS Access and it has > > been a solid and relieable app for creating PDF files. > > > > One particular client has a coloured JPG graphic header file which > > is attached to all their Access reports. All their reports print > > just fine except for one. There is no error but when this report is > > printed within the program the colour JPG header is conveted to > > monochrome.(?) > > > > > > If the report is printed in direct manual mode the report retains > > its colour... the problem only shows itself when printed within the > > program. It does not matter what OS is running XP/Vista/Windows7, or > > memory from 1GB to 8GB of RAM, or how many pages from 1 to 6 but > > there is one difference though. > > > > The report has a subreport. If the subreport is removed, back comes > > the colour. I have left a message on the PDFCreator forum but so far > > no responses but as the problem is a MS Access one if the question > > can be answered it would be here. > > > > TIA > > Jim > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com