Open up the report in design view. Then from the menu bar select
File - Page Setup and change the print settings as desired (margins, paper size, etc.) then save the report. The report will now have those characteristics embedded.
Ray
RaySmith
Last Activity: Jul 6 '07, 11:02 PM
Joined: Jul 5 '07
Location:
-
I export multiple reports to RTF files. Then from access, open word, run VBA code in Access to merge the output files into one Word documnet (essentially running a Word macro from withing Access). You must have to have the office and word libraries attached via references in your VBA module(s).
If you're using Word2007 then you would be able to save it as a PDF file.
The code for my sub is below. It's not tidy but it...Leave a comment:
No activity results to display
Leave a comment: