Hi,
Is it possible to control the formfeed in my report? Suppose I want to
turn off the form feed, how to do that?
TIA

Yanto

"yanto" <yanto2000 (AT) gmail (DOT) com> wrote

You have some control over spacing using the "Force New Page" and "Keep
Together" properties of the Report Sections. You can insert a Page Break
Control, and use code to set its .Visible property for some additional
control. These, of course, are useful in adding breaks, or new pages, not
suppressing them.

You may have noticed that you format reports for a particular printer or the
Windows default printer, and the Page Setup dialog boxes are coordinated
with the particular printer you've chosen. Because I've never had occasion
to use either roll paper or fanfold paper in recent years, I don't know
whether you have flexibility to use a margin of 0 on printers intended to
use that kind of paper.

My guess is that you would need to get "down and dirty" with printer control
codes to suppress the printer sending notification of "end of page" back to
your computer, and even then, I don't know how that would work with Page
Setup. Have you searched with Bing, Google, or within the Microsoft
Knowledge Base* on this subject?

* At http://support.microsoft.com

It may be that you will have to use Print commands, not Reports, to
accomplish what you want. Reports are intended to make it simple (simpler)
for users to create the common style of "banded" reports, not as the ONLY
way to print. My printing needs are well-covered by that "standard style",
and, thus, I have little or no experience with other ways of printing from
Access -- and, I think, most users are in a similar situation.

Larry Linson
Microsoft Office Access MVP

Hi Larry,

Thanks for response, I need to turn off the page break because some of
my customer using custom pagesize to print the receipt. As we know
that custom pagesize must be set in each komputer that use that
printer, because when I set in my home, then bring to customer place
all the papersize setting will change. so need to go to customer place
to set the paper size.
I found the solution to overcome this matter from internet (using
group and some code-trick) but unfortunately when finished the printer
will always eject the paper, my customer using roll paper to print.
Any idea to solve this? Anyway thanks for your oppinion, I appriciate
that.

Yanto

On Jan 23, 1:28*am, "Access Developer" <accde... (AT) gmail (DOT) com> wrote:

"yanto" <yanto2000 (AT) gmail (DOT) com> wrote

No, I have no suggestion for doing what you want with a Report.

Larry Linson
Microsoft Office Access MVP

"yanto" <yanto2000 (AT) gmail (DOT) com> wrote

Some additional searching led me to the following. It may not be exactly
what you want but the approach of selecting a printer and using the
Printer.Print method may allow you, with some work and experimentation, to
do what you want.

http://bytes.com/topic/access/answer...ing-win32-apiI am personally acquainted with some of the responders, and know them to bevery knowledgeable in classic Visual Basic and Visual Basic forApplications. Larry Linson Microsoft Office Access MVP