By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,474 Members | 1,283 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,474 IT Pros & Developers. It's quick & easy.

Print receipt on roll paper - dynamic length

P: 3
How to print in MS Access a report to a receipt printer like Epson TM-T20, TM-T88V, ...
Now I can only print fixed length reports. Purpose of roll paper is to cut the paper after last line of information.
Jan 8 '15 #1
Share this Question
Share on Google+
7 Replies


twinnyfo
Expert Mod 2.5K+
P: 3,482
Access Reports are limited in length to 22 Inches. I have not used Roll paper to test it, but I would think that you could print multiple pages using that type of paper.
Jan 8 '15 #2

Seth Schrock
Expert 2.5K+
P: 2,951
Total design length may be 22 inches, but if the number of records multiplies the detail section beyond 22 inches, thats fine.

@acc001, have you tried it or is this question preemptive?
Jan 8 '15 #3

P: 3
Hi,
Thanks for your reply. I tried it and for what I understand, is that I only can choose a paper size, e.g. A4, A5, letter, ...
So for every receipt I print, I get the length of an A4, A5 accordingly. Better would be to have only the length needed for the total length of items to be printed.

If I have a receipt of 5 items, the length of the printout should be: n_header + 5 x n_item + n_footer
If the receipt has 20 items, the length should be: n_header + 20 x n_item + n_footer

For now the best solution I can think of is to calculate the length, then choose the closest available papersize, set it and printout.

Question is how to set dimensions of paper size at printout?
Jan 9 '15 #4

twinnyfo
Expert Mod 2.5K+
P: 3,482
Ahhhhh, now I see your conundrum! Gone are the good ol' days where you could send one line to a printer.....

Hey! That's an idea..... Set the paper size to the height of one row of text with no top or bottom margins! Then, you are essentially printing a bunch of tiny pages (each item is a page). To print gaps between receipts, print several "blank pages".

It is thinking outside the box, but it just might work!
Jan 9 '15 #5

Seth Schrock
Expert 2.5K+
P: 2,951
I don't know what property you would need to set, but here is the list for Access 2010: Access 2010 Report Properties
Jan 9 '15 #6

Seth Schrock
Expert 2.5K+
P: 2,951
See How to dynamically resize a continuous dialog form. I know this is for a form, but it might work similar to a report.
Jan 9 '15 #7

P: 3
Thank you all, but can't solve it. Setting the paper size seems not possible? Only predefined size can by chosen. Tried to set report.height, but gives an error when applied after opening in designview and before printout. And when set instruction placed in onLoad event, then it has no effect.
Jan 9 '15 #8

Post your reply

Sign in to post your reply or Sign up for a free account.