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

On Apr 23, 12:06 pm, "Stephen Lebans" <ForEmailGotoMy.WebSite.-
WWWdotlebansdot...@xxxxxxxxxxxx> wrote:
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 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: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- Hide quoted text -

- Show quoted text -

Sorry - my response "I set my default settings on my printer (Legal
and Landscape were the changes) and it prints fine." should have said
"and the PDF run with that looks fine.

Access 2000 9.0.8981 SP-3

Sara
.

Relevant Pages

  • 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: Access "dies" printing PDFs
    ... If you report has images on it, ... Relative to Adobe Acrobat 6, it can be quite slow to output PDF files ... Settings dialog appears, on the compatability setting, try reducing it to ... > Dim SavePath As String ...
    (microsoft.public.access.reports)
  • Re: Report formatting Disappears on Some Items when Output to PDF in Code
    ... Size/Orientation for the report. ... Access Code, Tips and Tricks ... 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
    ... 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: Landscape Report prints in Portrait format
    ... I would edit the .FRX file and see what the settings are for the printer. ... orientation this is a 1 or 0 for landscape or portrait. ... Cathy Pountney's book "THE VISUAL FOXPRO REPORT WRITER" Lots of good stuff ...
    (microsoft.public.fox.programmer.exchange)