Variable length reports

[ryetee]

I've not researched this yet as I'm running on limited time BUT I have a task to fix a variable length print used as a till receipt. The width is perfect but I'm getting a full sized page printed out (either A4 or US letter) with hundreds of blank lines. Any idea what I'm missing. I have column size set to same as detail. I've specified a specific printer in page set up etc etc.
Any pointers gratefully received.

Also when I change setup it reverts to previous values sometimes and I can't seem to set right margin to zeero.

 

[Minty]

Try setting the paper size / type to continuous labels, otherwise it assumes its a page.

 

[ryetee]

Try setting the paper size / type to continuous labels, otherwise it assumes its a page.

OK but where is that? Is it in Page layout? If so I can't see it at all!

 

[Minty]

You may need to create a new Label report and then copy over your existing one into it.

 

[ryetee]

You may need to create a new Label report and then copy over your existing one into it.

I'm working on what appears to be a badly designed system that is very flaky and have no idea how it all hangs together so is there no other way in doing this by changing properties?

 

[ryetee]

So rthe printer has a height property which I can amend in page set up -> specific printer -> properties. However this isn't ideal. Most receipts are a similar depth but if only 1 item on receipt then have a bunch of blank lines and if over 10 items the receipt produces 2 pages. Can I, and if I can how do I, alter this printer property in VBA?

 

[gemma-the-husky]

can you check the query that drives the print.

I suspect there must be some extra (blank) rows being generated in the query.

 

[ryetee]

can you check the query that drives the print.

I suspect there must be some extra (blank) rows being generated in the query.

No it's definitely the printer settings. It's a wee zebra printer that prints of variable length prints.
If when printing off you go into the printers properties you can change the height (depth?) of the print page. It's set at 15 which most of the times leaves blank lines. If you change it to say 10 it doesn't but if you could potentially print 2 pages.Can I change this property of the printer from within VBA?

 

[Minty]

What happens if it prints 2 pages ? If you set it so that the header and footer of the receipt are both report header / footer sections rather than page sections I think you'll just get a print out that is as long as you need? Particularly if you set the label size so there is no gap between the "apparent" label size you put in.

 

[ryetee]

What happens if it prints 2 pages ? If you set it so that the header and footer of the receipt are both report header / footer sections rather than page sections I think you'll just get a print out that is as long as you need? Particularly if you set the label size so there is no gap between the "apparent" label size you put in.

If it can't fit all of the data onto the size defined in the printer properties it prints 2 or more pages I get the page header on all pages. If I move the page header into the report header I can still get more than 1 page with lots of blank lines but I, obviously, don't get the page header again. If it can't fit the report footer into the defined size ALL of the footer goes onto the subsequent page.

As I've said it I think it's down to the height/depth properties of the printer I need to change dynamically on the VBA code

 

[Minty]

Hmm - you'll need to do some some sums on the detail line heights then.
I'm not sure what is available for printer properties but http://www.access-programmers.co.uk/forums/showthread.php?t=184762 shows some of them.

 

[ryetee]

Hmm - you'll need to do some some sums on the detail line heights then.
I'm not sure what is available for printer properties but http://www.access-programmers.co.uk/forums/showthread.php?t=184762 shows some of them.

The sums are probably easy enough it's knowing what property to alter! At the moment I've set it to accommodate 95% of receipts...