How to print a Microsoft Access report without unwanted gap by using a dot-matrix printer?

Hi,

I would like to print a Microsoft Access report on the continuous paper by using a dot-matrix printer (Model: EPSON LQ-570e). The problem is how can I force the printer to print my output without rolling miles of paper (unwanted gap) after finishing printing. For example, if the report is only half page, then the paper will stop at the half page right after finishing printing. If the report is more then one page, then the printer will continue on next page without any gap and it will stop where the report is finished. Any comments is appreciated.
jagohoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

peter57rCommented:
Your question TITLE says that you want to REMOVE a gap.
Your QUESTION says that you have NO gap.

Would you like to clarify?

Pete



0
jagohoAuthor Commented:
Sorry about that my question is not clear

I want to REMOVE the gap between pages
0
jagohoAuthor Commented:
The following statement in my question is what I WANT my ouput to be.

"For example, if the report is only half page, then the paper will stop at the half page right after finishing printing. If the report is more then one page, then the printer will continue on next page without any gap and it will stop where the report is finished. Any comments is appreciated."
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

TextReportCommented:
Can you specify a custom paper size in your printer,. if so reduce the size of the page to the size of 1 record in the report.

Cheers, Andrew
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jagohoAuthor Commented:
But the length of the report is differnet every time when i want to print
0
TextReportCommented:
Try it a say 1 inch then it will only through out an inch max per page. Cheers, Andrew
0
jagohoAuthor Commented:
But the length of the report WILL be differnet every time when printing.
0
jagohoAuthor Commented:
My project is about an resturant ordering system. It needs to print out every customer's order so the length is different everytime
0
TextReportCommented:
I take it they are printing on a roll rather than perferated sheets of paper.

In access if you do not set the keep together properties then it will continue from page to page, even if that page is short.

Cheers, Andrew
0
jagohoAuthor Commented:
The following code can print "Hello World!" without any gap.
But I don't know how to use those code to print my report.

Private Sub Command83_Click()
Dim f As Integer
f = FreeFile()
Open "LPT1:" For Output As f
Print #f, "Hello World!"
Close f
End Sub

Please help me. Or if you know another way to solve my problem please let me know.

And I will try what Andrew suggested
Thank you Andrew
0
jagohoAuthor Commented:
Hi Andrew,

The paper i am using is continuous paper. They have holes on two sides.
Where I can find "keep together properties"? Should I set it true or false?
0
jagohoAuthor Commented:
I tried Andrew's suggestion, but it doesn't work.
Andrew or anyone who can help please help me
0
TextReportCommented:
Sorry the perferation I was on about is across the page rather than the sprocket feeds. Perhaps a better question is do you want the user just to cut the paper where it stops printing. Most continuous stationery is either 11 or 12 inches.

The Keep together property is on each section and in the sorting/grouping option and need to be No.

Cheers, Andrew
0
jagohoAuthor Commented:
I tried the Keep Together property, but it doesn't work. Because at the beginning it already set to be NO

My report contains 3 sub reports

Is there any way other than setting the paper size?



0
TextReportCommented:
the extra blank space that is printed is

1. the remainder of the current page
2. a page feed set by the spooler if printing across the network
3. any force new page after sections in the reports

all of the above should move the paper to the top of the next page.

HTH Andrew
0
jagohoAuthor Commented:
The extra blank space that is printed is the remainder of the current page.
0
jagohoAuthor Commented:
I just want to explain more clear for my problem. The following is what I need.

1. If the report is only half page, the printer will print half page plus 3 blank line space.

2. If the report is 2 pages, the printer will print page 1 & 2 plus 3 blank line space, and there is no blank space between page 1 & 2.

3. There is only 3 blank line space instead of the remainder of the current page between each report.
0
ornicarCommented:
----------------------------------------------------------------------------------------
This question has been abandoned and needs to be finalized.
 You can accept an answer, split the points, or get a refund (information at http:/help.jsp#hs5)
  If you need a moderator to help you, post a question at Community Support (http:/Community_Support/)

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

ornicar
Cleanup Volunteer

---------------------------------------------------------------------------------------------
0
jadedataMS Access Systems CreatorCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: TextReport {http:#9813709}

Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

jadedata
EE Cleanup Volunteer
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.