Newsletter #2
Perfect Labels and Badges

You may already be howling, "Perfect labels!? Are you nuts!!!?" Sounds as if you’ve had the maddening experience of seeing your text slide down the page and/or to the right until it doesn’t line up with the labels at all. It’s enough to make you pull your hair out! Well, read on. The secret is at hand!

What you get when printing labels (or badges) is determined by a combination of three things:
1) Page Setup (Print Setup for Windows users) under the File menu
2) The way your layout is arranged in Layout mode
3) The settings in the Layout Setup dialog under the Layouts menu. (You have to be in Layout mode to see the Layouts menu).

Before you even start setting up labels, choose the printer you’ll be using and make sure it’s set to Portrait – not Landscape. If you’re working with a layout that existed before you did that, just make the change now.

Go ahead and create the label layout and choose all the settings in those dialogs - or go to the layout you want to "fix" (I won’t show you how to make a label layout. This whole discussion pretty much assumes you’ve done labels before – just not successfully.)

While you’re in Layout mode (looking at the layout you want to work with), choose Layouts > Layout Setup and click the Printing tab. Near the bottom make sure the box next to "Fixed page margins" is checked.

Now here comes the good part:

* Put a 0 (zero) in each of the boxes for Top, Bottom, Left, and Right.

* When you click OK, FileMaker will complain, "Some margins are smaller than the minimum allowed by the printer…" Well, that sounds scary. But just click OK. Besides, you don’t get any choice in the matter. There is no Cancel button.

* Next you may get a dialog that says, "Do you want column widths on the layout recalculated to fit evenly in the available page area?" Click the Yes button.

* Make sure the Header is the same height as the white space before the first label on your label sheet. For a little help with the Header size, choose View > Graphic Rulers. Where the rulers meet in the upper left corner, you’ll either see px, in, or cm. You want the rulers to read in inches. If it doesn’t, click whatever is there until it reads "in." Now you can move the Header tab (or the dotted line) up or down until the Header is the right height.

* Instead of wasting another sheet of labels, test the alignment by printing one page on a blank sheet of paper. Stack it on top of a sheet of labels and hold it up to the light. You can see if you still need to make more adjustments.

* If the bottom few labels on the page don't print, make the Footer a little smaller and run a blank sheet of paper again. If the Footer is already only an eighth inch, try deleting it entirely.

Looks a lot better now doesn’t it? Why don’t they explain this in the manual? One final note - you may need to resize the Footer again if you change printers.

Anyway, that should solve your label printing problems. Glue your hair back in and send me a check! Now if I could only get envelopes to work the way they describe in the manual…

J **


Of course, the main purpose of this newsletter is to remind you that I'm here to serve your FileMaker needs - development, support, and training.

If you can think of anyone you might refer me to, I offer a 5% "Thank You!" for the first 2 years of billing on referrals.

< Back to In the News


Email us here.