Labels: adding text / spot printing

[lonesomejubilee]

Hi,

I use the standard FMP walk through to create labels (avery 5161 i think). The problem is that I want to add text, for instance "Original Price:" and then the price field, which works great, but here's the catch...

I don't always print out a page at a time so let's say I have a half sheet of labels and I need to print one label at position 18 on the label page... I clear out my current table and enter 17 "blank" entries and use #18 to land the printing on the label in the correct position. This works alright, but the problem is that when I enter the 17 "blank" entries it still prints "ORIGINAL:" with no price (because there is no information as it is blank).

Bottom line. I need to be able to drop a label at a specific area on the page. How do I avoid printing the added text of "Original price"? Or is there a better way to add text to my fields?

Thanks, Vandy

[CyborgSam]

Vandy->

Make a single calculation field for the label, and then have an If test to see if they should print, for example:

If( IsEmpty (FieldThatDeterminesIfThisLabeIShouldBePrinted) ;

"" ;

"Original: " & FieldThatDeterminesIfThisLabeIShouldBePrinted & "¶" & ...

)

[lonesomejubilee]

Where do I put this calculation... I can't put it in the label area, can I? (I mean the template label area, it would just come as text)

[CyborgSam]

Put the calculation in a new field, and then use that field for the label, expanding it to fit the label's size.