Hello FMP users:

I run FMP v.6 on Mac OS X.

I am getting a blank line in my  5160 labels. My layout looks like
this:

<<First Name>>  <<Last Name>>
<<2nd First Name>>  <<2nd Last Name>>
<<Extra Address Info>>
<<Street>>
<<City>>  <<State>>  <<Zip>>

In any record in which "2nd First Name" and "2nd Last Name" are blank,
there is a blank line. However, in any record in which "extra address
info" is blank, there is no blank line.

I went to the "help" viewer and got the following:

"Blank lines in labels: Check for extra returns in the field: on a
data-entry layout, go to the problem record and click into the field.
If it expands, there is an extra Return. Delete it."

The problem is that it is not just one record. It is all records with
no data in the "2nd First Name" and "2nd Last Name" fields. And yet
records with blank "extra address info" do not have a blank line
there.

Can anyone tell me how to get rid of that blank line?

If yes, please eMail me directly: philzone@tomrawson.com

Many thanks!

--Phil

In article <d2d45796.0309241555.50bbf5@posting.google.com>,
 philzone@tomrawson.com (Phil Zone) wrote:

> I run FMP v.6 on Mac OS X.
> 
> I am getting a blank line in my  5160 labels. My layout looks like
> this:
> 
> <<First Name>>  <<Last Name>>
> <<2nd First Name>>  <<2nd Last Name>>
> <<Extra Address Info>>
> <<Street>>
> <<City>>  <<State>>  <<Zip>>
> 
> In any record in which "2nd First Name" and "2nd Last Name" are blank,
> there is a blank line. However, in any record in which "extra address
> info" is blank, there is no blank line.
> 
> I went to the "help" viewer and got the following:
> 
> "Blank lines in labels: Check for extra returns in the field: on a
> data-entry layout, go to the problem record and click into the field.
> If it expands, there is an extra Return. Delete it."
> 
> The problem is that it is not just one record. It is all records with
> no data in the "2nd First Name" and "2nd Last Name" fields. And yet
> records with blank "extra address info" do not have a blank line
> there.
> 
> Can anyone tell me how to get rid of that blank line?

I think the problem is that you have two fields with a space between 
them for the 2nd name, whereas the extra address info is one field. In 
the former there will still be a space when the fields are blank. In the 
later there will be nothing in the line.

Make a computed field which concatenates the 2nd name intelligently and 
then use this field instead.

if(2nd first name = "",2nd last name, 2nd first name & " " & 2nd last 
name)

-- 
Matthew Smith
(to reply via email remove xxx)