Access 2007 & Printer control codes

[Guest]

My (POS) printer needs to receive the following - I think it is called escape
sequence code "LPRINT CHR$(29); CHR(86); CHR$(48)" in order to activate the
paper cutter at the end of a print report. Where and how do I have to place
this on the print report form?

Any ideas or clues?

Thanks,
Vassilis

 

[Paul Shapiro]

I haven't worked with printer control codes for a very long time, but you
could try putting a textbox at the end of your report and assigning it's
control source as:
=chr$(29) & "; " & chr$(86) & "; " & chr$(48)

That assumes the semi-colon and space are supposed to be part of the string,
which I do not think is correct? I think they're part of the LPrint syntax
indicating no spaces between the outputs. In that case, you would try:
=chr$(29) & chr$(86) & chr$(48)

Paul Shapiro

 

[Sascha Trowitzsch]

Hi Vassilis,

My (POS) printer needs to receive the following - I think it is called escape
sequence code "LPRINT CHR$(29); CHR(86); CHR$(48)" in order to activate the
paper cutter at the end of a print report. Where and how do I have to place
this on the print report form?

Any ideas or clues?

I'd consider to use OPOS when dealing with POS printers.
(http://monroecs.com/oposccos.htm)
Or at least you should only send escape sequences to the printer.
There are three issues with Access reports on POS printers:
- Output is very slow because you're using the windows (graphical) driver. Data
amount is large compared with ESC sequences and most POSprinters have only 19200
bit connections.
- Most POS printers even don't work with reports as their height is limited to
approx. 22 inches. But normally POS printers have a fixed height of 100 inches.
- Some commands as cut, paper feed, are only available through ESC sequences.

Ciao, Sascha