Label Printing

[dabineri]

Any ideas, using VB6 and CR7, how one can commence printing on sheet labels (say 3 across, 10 down) on a particular row rather than from the top of the page? Is there a formula that I might place in the document that would do this?

Any hints would be very welcome. David Abineri

 

[Ngolem]

Here is the answer I gave another person with the same problem a few weeks ago:

*********************************

Ok....here is what I would do

As a parameter I would have one that allowed a range AND multiple values...that way you can select descrete spots and/or a range of spots where you don't want labels printed

Determine the number of labels / page ... let us say there are 10 labels per page for sake of argument and they are laid out

Label_1 Label_2
Label_3 Label_4
Label_5 Label_6
Label_7 Label_8
Label_9 Label_10

Since we have determined that this is a "hard coded" sheet of labels then this would be done in a footer probably with each "Label" being a separate text field...or it could be formulas based on collected data then printed in a report footer (carefull about the 254 char limitation)

So the parameter would be used to indicate which labels you wanted printed

?LabelSelection
Type: number
Description: Type in the range or descrete label numbers that you want printed
Default: range the numbers from 1 to 10

Now in the in the conditional suppress of each label text field you would put a formula

eg. for Label_1

not( 1 in ?labelSelection )

eg. for Label_2

not( 2 in ?labelSelection )

So these fields are suppressed unless they are specified in the parameter ?LabelSelection

*******************************************************
Hope this helps
Jim
JimBroadbent@Hotmail.com