I understand that Microsoft do not have their own function in report to pdf conversion... however any 3rd party apps to recommend?

Access 2007 and 2010 have the built-in ability to save a report to PDF.

If you are using Access 2003 or earlier then check out this:

Stephen Lebans's Website (http://www.hitechcoach.com/index.php?option=com_weblinks&view=category&id=57%3Aaccess-example-databases-code-repository-sites&Itemid=23)
There you will find a free Report To PDF tool

thanks got it!

Glad to hear that will work for you.

Good luck with your project...

I'll just post back my solution to my problem.

I downloaded doPDF

from
http://download.cnet.com/doPDF-Free-PDF-Converter/3000-18497_4-10648880.html?tag=mncol

and it worked as a printer driver, so everytime i click print i select 'doPDF' as my printer source and it comes out as PDF file! sweet without a cent

I prefer this one:

PrimoPDF 5.1.0.2 (http://download.cnet.com/PrimoPDF/3000-18497_4-10264577.html?tag=mncol)
On CNET it has a Product Ranking of #1 in PDF Software

If your using Adobe Pro, the the ability to convert to PDF should be present in all office apps. Adobe Pro should install the adobe printer to your printers folder.