Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / December 2005

Tip: Looking for answers? Try searching our database.

Stephen Lebans A97ReportToPDF

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
RedFish - 30 Nov 2005 21:42 GMT
Is anyone using this?  How do you get a landscaped report to come out
correctly?  It always comes out portrait, guess I must be doing something
wrong.  If anyone can shed some light, that would be great.  Thanks a lot,

Redfish
Stephen Lebans - 30 Nov 2005 22:37 GMT
Portrait and Landscape work fine here. What happens when you convert the
sample CustomerLandscape report?

Signature

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

> Is anyone using this?  How do you get a landscaped report to come out
> correctly?  It always comes out portrait, guess I must be doing something
> wrong.  If anyone can shed some light, that would be great.  Thanks a lot,
>
> Redfish
RedFish - 30 Nov 2005 22:47 GMT
hmmm.. seems fine.  After further investigation, it appears that even though
the snapshots view correctly, they are being created with portrait checked,
rather than landscape.  When I try to print them, all the text is adjusted
and bunched together as the snapshot suddenly shifts into portrait mode.  I
use the ReportToPDF directly, haveing it create the snapshots and everything
for me, so I guess this would be why they get converted to portrait.  Must
be something wrong on my side, looks like I have some digging to do.  Any
suggestions?  Access 2000, Win2000.  Thanks,

Redfish

> Portrait and Landscape work fine here. What happens when you convert the
> sample CustomerLandscape report?
[quoted text clipped - 5 lines]
>>
>> Redfish
Stephen Lebans - 30 Nov 2005 23:29 GMT
Let's backup a second here. Forget about my code completely. Export the
report in question to Snapshot file format. What happens when you view and
then print this Snapshot within the MS Snapshot Viewer application.

Signature

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

> hmmm.. seems fine.  After further investigation, it appears that even
> though the snapshots view correctly, they are being created with portrait
[quoted text clipped - 16 lines]
>>>
>>> Redfish
RedFish - 01 Dec 2005 16:21 GMT
Agreed, after some testing, it appears this problem has nothing to do with
your code.  Here is what is happening.  In design view, the report is saved
as landscaped.  The I open the report and export it to snapshot.  When I
first open it in snapshot to view it, everything looks fine.  If I hit
print, the print layout tab says that it should be portrait, even though it
is viewed as landscape.  If I don't change it, (or didn't bother to look at
that tab at all, for instance), it prints out portrait.  As soon as the
print button is pressed, it also changes in the viewer to portrait mode.  I
can close the viewer and reopen, and it appears in landscape mode again, but
the same steps produce the same results.  I hope that is clear, as I really
don't know where to look for a solution to this.  Thanks for the help,

Redfish

> Let's backup a second here. Forget about my code completely. Export the
> report in question to Snapshot file format. What happens when you view and
[quoted text clipped - 21 lines]
>>>>
>>>> Redfish
RedFish - 01 Dec 2005 18:08 GMT
Actually, it appears to be working almost correctly at this point.  The
problem was on our end, with the format of reports being changed back and
forth by different people.  The only thing I'm running into now is that the
font, or at least the text size, in some text boxes, appears to be off after
the conversion to PDF.  Most reports we run are generic, with the client
name (part of the report header) being data driven.  Just using a textbox to
display the name.  It is right-aligned, and the resultant PDF always seems
to have the last few letters missing.  Any thoughts on that?  Thanks a lot,
have a great day!

Redfish

> Let's backup a second here. Forget about my code completely. Export the
> report in question to Snapshot file format. What happens when you view and
[quoted text clipped - 21 lines]
>>>>
>>>> Redfish
Stephen Lebans - 01 Dec 2005 21:45 GMT
Are you be chance using a System Bitmap font for the TextBox in question?
Change it to a non Bitmap font and the issue will go away.

Signature

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

> Actually, it appears to be working almost correctly at this point.  The
> problem was on our end, with the format of reports being changed back and
[quoted text clipped - 33 lines]
>>>>>
>>>>> Redfish
RedFish - 01 Dec 2005 22:13 GMT
How do I know:  Times New Roman, 24 pt, Bold, Italic.  Thanks a lot!

Redfish

> Are you be chance using a System Bitmap font for the TextBox in question?
> Change it to a non Bitmap font and the issue will go away.
[quoted text clipped - 36 lines]
>>>>>>
>>>>>> Redfish
RedFish - 01 Dec 2005 22:30 GMT
Okay, I changed to a non-true type font, it worked great.  Thank you very
much.  I don't suppose you know how to change all the font properties of the
labels and text boxes of several different reports in one fell swoop, do
you?  Thanks again, have a great evening!

Redfish

> Are you be chance using a System Bitmap font for the TextBox in question?
> Change it to a non Bitmap font and the issue will go away.
[quoted text clipped - 36 lines]
>>>>>>
>>>>>> Redfish
Stephen Lebans - 02 Dec 2005 00:13 GMT
Wait a minute, there should be no need to bother changing all of your
Reports. You already were using a non Bitmap font as True Type fonts are
vector based.

What font were you using?
Does this font related issue show up when you manually export the Repor to
Snapshot format?
Signature


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

> Okay, I changed to a non-true type font, it worked great.  Thank you very
> much.  I don't suppose you know how to change all the font properties of
[quoted text clipped - 43 lines]
>>>>>>>
>>>>>>> Redfish
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.