I have labels set up as follows:
Name
Contact
Address1
Address2
Address3
City State Zip
The query has clients from Department business and individual. There is a
contact name for all clinets, but where the client is an individual, the name
and contact anre the same. I don't want to show the contact where the
department is "Individual". The data for the Contact test box is
=IIf([DeptName]="Individual"," ",[Contact]).
Now the problem is when the label prints, it is showing as:
Name
Address1
Address2
Address3
City State Zip
What do I have to do to get rid of the blanks?
Rick B - 28 Oct 2005 16:08 GMT
Try the "can shrink" property. Or, set all the controls to one pixel high
and set the "can grow" property.

Signature
Rick B
>I have labels set up as follows:
>
[quoted text clipped - 23 lines]
>
> What do I have to do to get rid of the blanks?