Labels

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

Guest

I have a table with Name, Residential Address, Mailing Address(for PO boxes)
city, state, zip. I would like to have the labels be printed out so that if
there is a PO box, no residential address shows. And if there are no PO
boxes just the residential address shows. I am at a loss to whether this is
possible or not. Any help would be great. Thanks.
 
In the control source of a text box on your report put:
=iif(not isnull([Mailing Address]),[Mailing Address],[Residential Address])
The text box will now show the residential address if there is not any
mailing address
 
Back
Top