Mailing Labels

  • Thread starter Thread starter Matthew
  • Start date Start date
M

Matthew

I am making mailing labels; I would like to skip the line "address2" if
there is no data on it. If there is data, I obviousally want to show it.

How is this done?

Matthew
 
Include Address2 in the query your labels are based on and include a textbox for
Address2 on your label. Go to design view for your label, select the Address2
textbox, open properties, go to the Format tab and set the can chrink property
to Yes. When you do this, the Address2 textbox will hrink to zero height when
their is no value for Address2.
 
Back
Top