Export Report as jpeg (in color)

[Kupot]

Ok, here comes a hard one...



At least measured by the amount of threads I have read without seeing a solution that is clear and succinct...

So, even if its not clear or succinct... Does anyone know how to Export a Report as:

a) a .pdf in full color and then convert to a jpeg from there. (using vba code)

b) a .jpeg in full color (more immediate than the above, again using vba code)

I would like to do this without using thirdparty software such as pdf995 or cutepdf...

I suspect I am looking for a "DoCmd.OutputTo" or similar code that would do the above.. preferrably option (b).

Thanks in advance!

[thhui]

In Access report, you could only export to rtf and excel.
For rtf, its format is much alike the access report.
For excel, format is cleared out partially.

Any other exported format could only get its underlying data.

So, I would suggest you printing it in pdf file (using pdf printer) and then make the conversion.

No vba could help this unless you buy any third party software.

NB: Chart as an OLEObject in a form could be exported to jpg.