ReportToPDF for Legal Size reports

[rbm]

First, I must thank Mr. Lebans for the use of his ReportToPDF function. It
has worked wonderfully for me.

I have one issue with generating pdf files for legal-sized reports in
landscape format. Lines, both horizontal and vertical, on the right side of
the report are missing. The text adjacent to those lines is still there
however. All of the lines are created using zero-height/width boxes and have
a line size of 1pt. The "missing" lines are in the area that is beyond the
area that would be included in a letter-size report. (These lines do show
correctly when the reports are converted to a snp file)

I can work around this by changing the preferences on my default printer to
select legal size paper before I generate the pdf file. When I do this, the
lines are all there. I can live with this but it isn't always easy to
explain to some of the users of my application. Does anyone know of another
solution to this?

 

[Douglas J. Steele]

I haven't bothered testing, but you could use the Printer Change Code Albert
Kallal has at http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
to change the default printer before generating the report.

Depending on what version of Access you're using, you should also be able to
explicitly set the PaperSize property of the Printer object:

Application.Printers(0).PaperSize = acPRPSLegal

(Sorry, I can't remember when the Printer object was introduced: whether it
was Access 2000 or Access 2002)

 

[rbm]

Thank you for the quick response. I will try your suggestions but I may be
out of luck because the application was developed in Access97. I use later
versions myself, but have the toolkit for 97 and like the lower overhead by
using that version.

 

[Stephen Lebans]

I have seen this happen if your default printer is a PDF driver or the
Microsoft Office DOcumnet Image Writer driver.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[rbm]

In this case, the default printer is an HP Photosmart 3300 All-In-One. I
also tried it with a Canon iP4300 as the default printer and had the same
results. If I set the default printer to legal size paper, it works fine.

 

[Douglas J. Steele]

Albert has a version of the Printer Change Code for Access 97, so as long as
your clients have an appropriate printer defined, you should be okay.

 

[rbm]

Thanks, I'll give it a try.

Albert has a version of the Printer Change Code for Access 97, so as long as
your clients have an appropriate printer defined, you should be okay.

 

[Stephen Lebans]

Hmmm... are you sure you have the latest version of ReportToPDF,
specifically the StrStorage.DLL library? Do a Search to verify that you only
have one copy of this file on your system.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[rbm]

I did have several copies of the 88K, 3/22/06 version of StrStorage.DLL.
They were in subdirectories of various versions of my software. I renamed
all of them except for the one in my Program Files version of my software.
Same results.

I also moved the single StrStorage.DLL and dynapdf.dll from the application
directory to the Windows\System32 directory with the same result.

The link below is to an Access97 mdb file containing a sample of the report
("lines" only) and the code used to save it to pdf - called
BracketSheetsLegal() in the modReportToPDF module

http://www.brownbagdata.com/downloads/LegalReport.mdb