I have a report that has and 8.5x11 image control on the page.
Background of the report: I am using VBA to scan documents in as jpeg files and then using the access report to combine the jpegs and then convert them to 1 pdf document.
This process works fine, the issue I am having is when I output the report that has 20 pages (20 jpegs) to PDF, the file size is up around 30MB.
Is there a better way to export this report so that the file size is much smaller?
Is there a way to just export a snapshot of the file and then convert to PDF so that it doesn't see the image control as an image?
Background of the report: I am using VBA to scan documents in as jpeg files and then using the access report to combine the jpegs and then convert them to 1 pdf document.
This process works fine, the issue I am having is when I output the report that has 20 pages (20 jpegs) to PDF, the file size is up around 30MB.
Is there a better way to export this report so that the file size is much smaller?
Is there a way to just export a snapshot of the file and then convert to PDF so that it doesn't see the image control as an image?
