Hi all
I am trying to set up a macro (or code) that will print a report, choosing 
the acrobat distiller as the printer.  I see the "Print Out" function in 
macro's doesn't allow you to choose the printer. 
Liz

Liz

I think you need Access XP before you can choose which printer to use to print a report - but, assuming every user has the correct
printer driver installed, there is another method.

Open up your report.
Choose 'Page Setup' from the 'File' menu.
Click on the 'Page' tab.
Click on the 'Use specific Printer' radio button and click on the 'Printer...' button.
Choose the Distiller printer driver from the list.

You'll need to test what happens when you try and print the report on a PC that doesn't have the distiller driver installed.

Brian

>  from:    Liz Haskin <liz@t...>
>  date:    Fri, 28 Feb 2003 15:02:36
>  to:      access@p...
>  subject: Re: [access] code to pdf
> 
> Hi all
> I am trying to set up a macro (or code) that will print a report, choosing 
> the acrobat distiller as the printer.  I see the "Print Out" function in 
> macro's doesn't allow you to choose the printer. 
> Liz

Liz,

<< I am trying to set up a macro (or code) that will print a report, 
choosing the acrobat distiller as the printer.  I see the "Print Out" 
function in macro's doesn't allow you to choose the printer. >>

Brian's solution involves the user having to MANUALLY reset the printer to 
the Acrobat distiller.  If you want to do it automatically via code, you 
must use the .Printer object.  Read about it on Access help.  There you 
can list your valid printers, find which one is the distiller, and then 
set the printer to that one.  Don't forget to reset the printer back to 
the default after you print to a PDF file!

Greg