ReportToPDF for Legal Size reports

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rbm - 30 Dec 2006 19:03 GMT

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?

Reply to this Message

Douglas J. Steele - 30 Dec 2006 20:17 GMT

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)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> First, I must thank Mr. Lebans for the use of his ReportToPDF function.
> It
[quoted text clipped - 19 lines]
> another
> solution to this?

Reply to this Message

rbm - 30 Dec 2006 20:37 GMT

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.

Reply to this Message

Douglas J. Steele - 30 Dec 2006 22:13 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Thank you for the quick response. I will try your suggestions but I may
> be
[quoted text clipped - 3 lines]
> by
> using that version.

Reply to this Message

rbm - 30 Dec 2006 22:47 GMT

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.
[quoted text clipped - 6 lines]
> > by
> > using that version.

Reply to this Message

Stephen Lebans - 30 Dec 2006 21:36 GMT

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

Signature

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

> First, I must thank Mr. Lebans for the use of his ReportToPDF function.
> It
[quoted text clipped - 19 lines]
> another
> solution to this?

Reply to this Message

rbm - 30 Dec 2006 22:01 GMT

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.

> I have seen this happen if your default printer is a PDF driver or the
> Microsoft Office DOcumnet Image Writer driver.
[quoted text clipped - 22 lines]
> > another
> > solution to this?

Reply to this Message

Stephen Lebans - 31 Dec 2006 13:17 GMT

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.

Signature

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

> 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
[quoted text clipped - 32 lines]
>> > another
>> > solution to this?

Reply to this Message

rbm - 31 Dec 2006 15:48 GMT

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

> Hmmm... are you sure you have the latest version of ReportToPDF,
> specifically the StrStorage.DLL library? Do a Search to verify that you only
[quoted text clipped - 36 lines]
> >> > another
> >> > solution to this?

Reply to this Message