Relay-Version: version B 2.10 5/3/83; site utzoo.UUCP Path: utzoo!utgpu!water!watmath!clyde!rutgers!sri-spam!ames!sdcsvax!ucsdhub!hp-sdd!hplabs!hpda!hpcupt1!tsu From: tsu@hpcupt1.UUCP Newsgroups: comp.databases Subject: Problem with dBase LABEL FORM command Message-ID: <5910001@hpcupt1.HP.COM> Date: Wed, 18-Nov-87 18:02:45 EST Article-I.D.: hpcupt1.5910001 Posted: Wed Nov 18 18:02:45 1987 Date-Received: Sat, 21-Nov-87 11:42:39 EST Organization: Hewlett Packard, Cupertino Lines: 80 XACT ON && Watch out for the dBase line-eater! Gentle dBase users: I have a problem with LABEL FORM that appears unsolvable. I would've ordinarily gone to Ashton-Tate support, but I'm in the same boat as the last fellow. The problem is printing 5-line labels using the 3.5 x 2.75 x 3 label forms. We set the #lines-in-label to 5 and #lines-between-labels to 1. Thus we can print 3 labels across and 11 labels down. But since we are printing to a HP LaserJet and there is an 1/2" unprintable region at the top and bottom of the page, we only print 3 labels across and 9 labels down - the top and bottom rows are unused. To accomplish this, we rigged up a quick BASIC program that sets the top margin to 5 and the #lines-of-text to 54 (6 lines per label x 9 labels going down the page). THE PROBLEM: Apparently, with the last label on a page, the fifth line does not get printed out there, but rather gets printed out on the fifth line of next page (ie on the unused top row of labels). That is instead of getting the following on the last used row of labels, ---------------------------------------------------------------------- *Joe Smith Barbara Connell Pamela Thomas President Vice-President Manager Smith Computers XYZ Corporation PPT Enterprises 123 Main Street 135 Elm Street 456 Oak Lane Cupertino, CA 95014 San Jose, CA 95503 Santa Clara, CA 95051 ---------------------------------------------------------------------- we get: ---------------------------------------------------------------------- Joe Smith Barbara Connell Pamela Thomas President Vice-President Manager Smith Computers XYZ Corporation PPT Enterprises 123 Main Street 135 Elm Street 456 Oak Lane ---------------------------------------------------------------------- and on top of the next page, we get: ---------------------------------------------------------------------- Cupertino, CA 95014 San Jose, CA 95503 Santa Clara, CA 95051 ---------------------------------------------------------------------- The next page appears normal, until we get to last row of the page. The problem is not with the unprintable region of the LaserJet because if we change the #lines-of-text to a multiple of 6 other than 54 (eg 48), we still have the problem. We changed the #lines-in-label to 6 and #lines-between-labels to 0, but this did not change anything. Finally, we changed the #lines-of-text to 55. This worked for the first page, but skewed the output for succeeding pages. A workaround is to save the top row of labels and to paste these labels with the cut-off part, but this is irritating and time-consuming. Any solution, workarounds, suggestions are welcome!! Please mail to me at {cbosgd,decwrl,hplabs,seismo,ucbvax}!hpda!tsu or post a response. The best solution(s) will be posted if mailed to me. THANKS IN ADVANCE!!! Stanley Tsu *All names used as examples are purely fictitious. Any resemblance to any person, living or dead, is coincidental. deBase is a trademark of Ashton-Tate.