Re: Report formatting Disappears on Some Items when Output to PDF in Code

Sara I don't see the answer to my question to you. What happens when you set
the Default printer manually(via the Control Panel, to Landscape/Legal and
then use my ReportToPDF code to produce a PDF?

Finally, there are several report related issues with the first release of
Access 2000. Can you check the installs and see what version of Access you
are actually using? Menu - Help -About

--

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


"sara" <saraqpost@xxxxxxxxx> wrote in message
news:3e55ea84-f8bb-4b0f-9aca-a0b5352a93b7@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Apr 23, 8:40 am, "Stephen Lebans" <ForEmailGotoMy.WebSite.-
WWWdotlebansdot...@xxxxxxxxxxxx> wrote:
Sara forget about my code for a moment. Manually open the report and
export
it to Snapshot format. Is the formatting correct in the Snapshot?

To verify it is not a Printer driver issue, setup the Default printer for
your computer to match what is required for your report(Portrait/Landscape
amd Paper Size. Now use my code to putput your Report to PDF.

Let me know.

--

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

"sara" <saraqp...@xxxxxxxxx> wrote in message

news:b4b349b9-37d1-4943-ab1f-30859585ccab@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



Hi -

I have a report that is 14 columnar sub-reports (Line up: Position-
holders in each of our 14 locations - Manager, Assistant Manager,
Receiving, Office, etc).

I output directly to PDF (using ConvertReportToPDF from this site -
Stephan Lebans)

The formatting - Outlines on some fields - do not appear on subreports
12-14 (Columns 12 - 14).

I tried removing some of the boxes around some fields, thinking that
it was just "too much" somewhere, but that didn't work.

Any ideas? I don't know if I have to email the mdb and data for
someone to figure this out. I have used the code to write to PDF
before - no problem. And this writes to PDF, just loses some
formatting lines.

thanks -
sara- Hide quoted text -

- Show quoted text -

I don't think it's the code - I use this code in several places and
have Never had a problem. But this is the first time this has
happened.

It does print in Snapshot format - all perfectly. I should have
posted that yesterday - sorry.

I set my default settings on my printer (Legal and Landscape were the
changes) and it prints fine. I printed an Outlook calendar page and a
page of a Word document - no problem - with the changed settings.

I returned the settings (Letter and Portrait) and the "lines around
the boxes" on the 3 columns on the far right disappeared again.

Also - though I think this is a different problem - (But just in case,
I'll mention it) - when the user ran the report (from her PC, and
would print on her printer) the report went to Letter size paper -
landscape. The PDF file shows 2 pages letter-sized.

Does this help? I am running an MDE (it happens in the MDB also), and
using A2K.

Thanks so very much -
Sara


.

Relevant Pages

  • Re: Export report as PDF
    ... landscape in design will it output a landscape PDF with PDFWriter (or ... Even if the report is set to landscape in ... Thats' one reason that our PDF and Mail Library for Access provides the ... Google search on PDF drivers to see others. ...
    (microsoft.public.access.externaldata)
  • Re: Report formatting Disappears on Some Items when Output to PDF in Code
    ... Now use my code to putput your Report to PDF. ... I set my default settings on my printer (Legal and Landscape were the ...
    (comp.databases.ms-access)
  • Re: Export report as PDF
    ... driver I mentioned. ... its not necessarily true that setting the report to ... > landscape in design will it output a landscape PDF with PDFWriter (or ... > Thats' one reason that our PDF and Mail Library for Access provides the ...
    (microsoft.public.access.externaldata)
  • Re: Report formatting Disappears on Some Items when Output to PDF in Code
    ... Now use my code to putput your Report to PDF. ... It does print in Snapshot format - all perfectly. ... I set my default settings on my printer (Legal and Landscape were the ...
    (comp.databases.ms-access)
  • Re: Export report as PDF
    ... landscape, it will be written to a PDF file in landscape. ... But when I tried to save a report to PDF as Landscape, ... > Google search on PDF drivers to see others. ...
    (microsoft.public.access.externaldata)