View original (French)

Printing ticket in Access

Solved
C-line- Posted messages 3 Status Member -  
C-line- Posted messages 3 Status Member -
Hello everyone,

I created an application (Access 2010) to manage the cash register and inventory of my store (which is set to open in a week).

I created a report (based on a form) for printing my tickets.
My report includes a page header, a detail area, and a footer.
But I have a problem when printing.

I want to print this report on my receipt printer (EPSON TM-T20II Receipt).
I have set this printer as the default for this report. And I chose the paper size of my rolls (Roll Paper 80x297mm).

Access properly recognizes the paper width.
The problem is that it seems to treat the length (297mm) as a fixed length.
So it prints the header and the detail correctly. Then, it leaves a loooooong blank space before printing the footer.

I would obviously like it to print my footer immediately after the detail ends.

Do you know what I need to do to fix this?

Thank you very much in advance!

4 answers

  1. castours
     
    Hello
    a suggestion. Revisit the design and format of your report. Maybe a label format
    would work.
    0
  2. C-line- Posted messages 3 Status Member
     
    Thank you, Castours.

    Unfortunately, the label format isn't working. It needs to have defined dimensions...

    In the format of my report, I have specified the type of paper; I don't see what else to do... :-(
    0
    1. castours
       
      So try a format of a state with the width of your roll and a minimum height of 5 cm
      Pay attention to the text format and character size so that the information fits on one line.
      0
  3. Tessel75
     
    Hello,
    I would suggest you drop the footer as such and prefer a footer from another variable selection, for example Sale No where you would include the same information as in the footer. But that won't address the length of each ticket.

    (To Castours: Where are we on the issue you were seeking advice on?)
    0
    1. castours
       
      Hello Tessel
      I dropped the issue. I'll look into it another time if the opportunity arises.
      Thanks anyway
      0
  4. C-line- Posted messages 3 Status Member
     
    Hello,

    Thank you for your responses.
    After fiddling around with all the printer settings (including a complete reinstall) without results, and tinkering with the adjustments (length, etc.), I ended up trying something new (based on what Tessel75 said) that worked! Yayyyyyyyy! :)

    In fact, I "simply" put the footer information in the status footer. And voila, magic, everything was resolved! :-)
    When I think about all the time I spent on such a silly thing... ;-)

    Thanks again for your help and have a great day!
    0