Report Printing / Custom Paper Size

[Fred Block]

Hi All,

I have a report that needs to be printed on a dot-matrix printer (and this
is not the default printer). The area of one form, not including the tractor
feed area, is 8.5" wide x 7" high. In the Access report designer, the
report's size is: 8" wide x 6.5" high. For the Page Setup I have all of the
margins set to .25" (for Top, Bottom, Left, Right).


My questions are these:

1. For the report's Page Setup / Orientation, which is the correct format to
use: "Portrait" or "Landscape"?

2. On the Page Setup / Columns tab, what should the "Column Size" settings
be (Width and Height)?

3. A custom paper size in Windows needs to be created for this. What would
the size of that paper need to be?


Thanks in advance!

Kind regards - Fred

 

[Guest]

Fred......

It sounds like you could use what is called "conditional page break". You
can do this very easily when printing forms. With reports it takes some VBA
code. I have been away from Access several years and now I am have my own
problems with printing with a dot matrix printer.
The VBA code has to do with counting the number of lines and changing the
Visible property to "true" otherwise the Visible property is "false". I can't
find my book that I kept all of these routines in. This post is just for
what it's worth. I just wanted to point you in another direction. Hope it
helps.