Labels with blank text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Try the "can shrink" property. Or, set all the controls to one pixel high
and set the "can grow" property.
 
Back
Top