[AccessD] Skip labels in report

Carolyn Johnson cjlabs at att.net
Tue Jan 17 20:01:39 CST 2012


I have been using code to skip labels so that the new labels start printing after the used ones.  This is the code that Microsoft has -- entering a number of labels to skip and using me.nextrecord and me.printsection to move to the correct label.   The code works fine if I have the labels set up to print across, then down.

However, if I change the labels to print down, then across, I cannot skip beyond the first column of labels.   For example, I want to print the next label in row 3 column 2 of a 30 label sheet (3 columns of 10 labels).  Printing down, then across means I am skipping 12 labels.  When I enter 12 however, it puts the next label in row 1 of column 2, not row 3.

If the report is set up to print across, then down and I skip 7 labels, it prints in the correct place.

I can't find any information on why this is happening or how to fix it.   For my purposes, it is much easier to use the labels if they print down first.

Any help would be appreciated.




Thanks
Carolyn Johnson


More information about the AccessD mailing list