Converting to PDF

[g diddy]

Hi
currently I am outputting reports (in access 2003) as rtf but I would like to output, instead, as PDF.
Here is the code associated with outputting as rtf:

DoCmd.OutputTo acReport, MyChoice, acFormatRTF, "c:\" & MyReport & ".rtf", False, ""
 

and

Set oAttach = .Attachments.Add("c:\" & MyReport & ".rtf")
 

What would I need to change it to to print as PDF? As well as changing these is there anything else I would need to do?

Thanks!

[Stewart Ross]

Hi g-diddy. In your previous post on much the same topic - linked here - you were given a link by AJalwaysus to Stephen Lebans website where there is a sample database which provides output to PDF.

In Access 2003 there is no simple way to output to PDF, which is why the Lebans solution is very valuable.

As we have already answered your question - albeit you may not think we have - I will close this thread to avoid duplication of effort from the volunteer experts who have already helped you along the way.

-Stewart