How to fit in one page while printing

  • Thread starter Thread starter Volkan
  • Start date Start date
V

Volkan

I have a report which different users print by using
different printers. It is hard to setup the printer
settings for all these various printers. On some printers,
the reports would fit on a "Legal" size paper all good but
would not fit on another printer. I was wondering if there
was any way to make the page fit to one page when
printing. Thanks.
 
Volkan said:
I have a report which different users print by using
different printers. It is hard to setup the printer
settings for all these various printers. On some printers,
the reports would fit on a "Legal" size paper all good but
would not fit on another printer. I was wondering if there
was any way to make the page fit to one page when
printing. Thanks.
Click to expand...


You'll have to increase the report's margins to those
required by the worst case printer. Of course, you'll
probably have trouble getting everything to fit on a page
then, so you'll have to fuss with the report to scrunch
everything together a little tighter (using a slightly
smaller font?)
 
Thanks Marsh. I tried all of the things you have
recommended but the report loses its formatting and appeal
after a while. So there is no VBA code to make it fit in
one page no matter which printer I select to print?
 
Thanks Marsh. I tried all of the things you have
recommended but the report loses its formatting and appeal
after a while. So there is no VBA code to make it fit in
one page no matter which printer I select to print?
Click to expand...

I understand the problem, but I've always been able to
reduce the font, rearrange the controls or get rid of some
data of lesser importance whenever I've run into the odd
printer with oversized margin requirements.

Access does not have a size to fit for printing feature.
After all, even it did, it wouldn't do any more than you can
by reducing the size of controls and fonts.

I've never ad to resort to third party products such as a
PDF writer, but I'm pretty sure that some of them can do
what you want. Maybe someone else can recommend one if
that's the route you want to take.
--
Marsh
MVP [MS Access]


 
It all depends on the user's preference at this moment
then. The font size is already 8. Perhaps we can split the
report if necessary. Thanks for your help though.
-----Original Message-----
Thanks Marsh. I tried all of the things you have
recommended but the report loses its formatting and appeal
after a while. So there is no VBA code to make it fit in
one page no matter which printer I select to print?
Click to expand...

I understand the problem, but I've always been able to
reduce the font, rearrange the controls or get rid of some
data of lesser importance whenever I've run into the odd
printer with oversized margin requirements.

Access does not have a size to fit for printing feature.
After all, even it did, it wouldn't do any more than you can
by reducing the size of controls and fonts.

I've never ad to resort to third party products such as a
PDF writer, but I'm pretty sure that some of them can do
what you want. Maybe someone else can recommend one if
that's the route you want to take.
--
Marsh
MVP [MS Access]



.
Click to expand...
 
Volkan said:
It all depends on the user's preference at this moment
then. The font size is already 8. Perhaps we can split the
report if necessary. Thanks for your help though.
Click to expand...

Maybe you could impose a printer purchasing standard that
specified the maximum margin requirements.

Then, at least you'd have a leg to stand on when told them
to trash their funky printers ;-))
--
Marsh
MVP [MS Access]


-----Original Message-----
Thanks Marsh. I tried all of the things you have
recommended but the report loses its formatting and appeal
after a while. So there is no VBA code to make it fit in
one page no matter which printer I select to print?
Click to expand...

I understand the problem, but I've always been able to
reduce the font, rearrange the controls or get rid of some
data of lesser importance whenever I've run into the odd
printer with oversized margin requirements.

Access does not have a size to fit for printing feature.
After all, even it did, it wouldn't do any more than you can
by reducing the size of controls and fonts.

I've never ad to resort to third party products such as a
PDF writer, but I'm pretty sure that some of them can do
what you want. Maybe someone else can recommend one if
that's the route you want to take.
--
Marsh
MVP [MS Access]


-----Original Message-----
Volkan wrote:

I have a report which different users print by using
different printers. It is hard to setup the printer
settings for all these various printers. On some
printers,
the reports would fit on a "Legal" size paper all good
but
would not fit on another printer. I was wondering if
there
was any way to make the page fit to one page when
printing. Thanks.


You'll have to increase the report's margins to those
required by the worst case printer. Of course, you'll
probably have trouble getting everything to fit on a page
then, so you'll have to fuss with the report to scrunch
everything together a little tighter (using a slightly
smaller font?)
Click to expand...

.
Click to expand...
Click to expand...
 
Volkan said:
Do you know if any VBA code would make the report fit in
one page while printing?
Click to expand...


No, I don't.

I hate toi say something can not be done in code, so I
presume that it's possible, but I would not want to try it.
Like I said before, an automatic reduction will be no better
than you can do by using a smaller font and controls.

In really tough situations suach as you seem to be in, I
just tell the people with a funky printer that they just
can't get good output and that they should either print to
the server's printer or buy a better printer.
 
Back
Top