Labels with blank text box

B

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?
 
R

Rick B

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top