Mailing Labels

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
 
P

PC Datasheet

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.
 
Top