Printing on a non-standard paper size (custom)

[Brewtzaff]

Hello,
I have a little problem to print my reports on custom sized paper.

I got a db containing clubmembers, a query which selects only the
needed infos to print out my membershipcards.

My card is 79mm high and 210 mm large, and each card is on a paper with
the same size, but I'm unable (don't know really how) to create a
report to print out my cards as defined.

Can someone help me out? And explain me how to do it.

Cheers

Brewtzaff

[Larry Linson]

First, understand that much of the "print" control depends on Access
interacting with the software drivers for the printer you have chosen as
default, or have specifically selected in Print Setup. And, if your printer
will not handle paper that small, you just cannot do what you want. (And,
interestingly, none of the printers that I use will handle paper with a
dimension as small as 79mm. In measurements I normally use that is 3.11
inches, and the minimum dimension for my printers is approximately 4
inches.)

Create a Report, using a Query that returns the necessary information from
your Table(s). First, on the menu File | Page Setup, and in the dialog,
choose a paper size the paper size that is the size of your card (if you do
not have the exact size as an option, choose the size closest to but smaller
than the actual card size). Set the margins as you wish.

Eliminate all Sections except the Detail Section. Set the dimensions of the
Detail Section to the paper size you selected in Page Setup, less the
margins you defined (or smaller). In the Properties Sheet for the Detail
Section, set the Force New Page property to "After Section." You can create
the Text Boxes on your report either manually, or using one of the Report
Wizards.

Provided your printer can physically handle a card as small as you
describe*, this should give you what you want. If you've made a mistake or
two in manually sizing the Detail Section, going in to its Properties Sheet
will allow you to enter the numbers exactly.

* I am not too hopeful about that, because my recollection
is that only some specialty printers will handle paper or
cards that small.

Larry Linson
Microsoft Access MVP

"Brewtzaff" <br*******@gmail.comwrote in message
news:11*********************@k70g2000cwa.googlegro ups.com...

Hello,
I have a little problem to print my reports on custom sized paper.

I got a db containing clubmembers, a query which selects only the
needed infos to print out my membershipcards.

My card is 79mm high and 210 mm large, and each card is on a paper with
the same size, but I'm unable (don't know really how) to create a
report to print out my cards as defined.

Can someone help me out? And explain me how to do it.

Cheers

Brewtzaff

[salad]

Larry Linson wrote:

First, understand that much of the "print" control depends on Access
interacting with the software drivers for the printer you have chosen as
default, or have specifically selected in Print Setup. And, if your printer
will not handle paper that small, you just cannot do what you want. (And,
interestingly, none of the printers that I use will handle paper with a
dimension as small as 79mm. In measurements I normally use that is 3.11
inches, and the minimum dimension for my printers is approximately 4
inches.)

I remember in the past one could create a customized size of paper. On
my current printer list I could not do that...so I don't know if that's
an old feature in Windows or if it still exists with some print drivers.

[Larry Linson]

"salad" <oi*@vinegar.comwrote in message
news:VN****************@newsread3.news.pas.earthli nk.net...

Larry Linson wrote:

>First, understand that much of the "print" control depends on Access
interacting with the software drivers for the printer you have chosen as
default, or have specifically selected in Print Setup. And, if your
printer will not handle paper that small, you just cannot do what you
want. (And, interestingly, none of the printers that I use will handle
paper with a dimension as small as 79mm. In measurements I normally use
that is 3.11 inches, and the minimum dimension for my printers is
approximately 4 inches.)

I remember in the past one could create a customized size of paper. On my
current printer list I could not do that...so I don't know if that's an
old feature in Windows or if it still exists with some print drivers.

Yes, I believe I have done that, but no "custom" option is available on any
of the printers in my list in Access 2002... the only version I have working
on this notebook (need to repair the install of 2003). But Word 2003 has the
option of entering width and height, so I guess it is not just the printer
driver software.

Larry Linson
Microsoft Access MVP

[Arno R]

"salad" <oi*@vinegar.comschreef in bericht news:VN****************@newsread3.news.pas.earthli nk.net...

Larry Linson wrote:

>First, understand that much of the "print" control depends on Access
interacting with the software drivers for the printer you have chosen as
default, or have specifically selected in Print Setup. And, if your printer
will not handle paper that small, you just cannot do what you want. (And,
interestingly, none of the printers that I use will handle paper with a
dimension as small as 79mm. In measurements I normally use that is 3.11
inches, and the minimum dimension for my printers is approximately 4
inches.)

I remember in the past one could create a customized size of paper. On
my current printer list I could not do that...so I don't know if that's
an old feature in Windows or if it still exists with some print drivers.

I guess you need to go to the PrinterServer and create your custom 'form' there.
If the form does not appear in the list, try to adapt the settings for a form that does appear...

See: http://support.microsoft.com/kb/157172

Arno R

[Lyle Fairfield]

Brewtzaff wrote:

Hello,
I have a little problem to print my reports on custom sized paper.

I got a db containing clubmembers, a query which selects only the
needed infos to print out my membershipcards.

My card is 79mm high and 210 mm large, and each card is on a paper with
the same size, but I'm unable (don't know really how) to create a
report to print out my cards as defined.

Can someone help me out? And explain me how to do it.

Cheers

Brewtzaff

Why not choose a paper size bigger than your cards in each dimension
and format your report to print only to the size of your cards (of
course you must include margins in your calculations and probably it
would be a good idea to leave a few millimeters for safety)? Then run
the report with your cards. Obviously, Access won't print beyond your
cards and will leave the rest of the sheet empty. Will it know there is
no "rest of the sheet"? It never has here in Canader and I have done
this frequently.

[Brewtzaff]

Thx to all of you,
I'll try asap, but i'm not working on this project for the moment as
this is a hobby project.

We use Filemaker for the moment and the guy who designed the db and the
reports did it, but as i don't know him....

So i started to take over the datas and after a long clean up, i
imported them in access,

I'll keep you in touch.

Thx again
brewtzaff