Labels with blank text box

[Baffee]

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]

Try the "can shrink" property. Or, set all the controls to one pixel high
and set the "can grow" property.