Labels

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

Guest

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
 

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

Similar Threads

Address 1
Subform causing duplicate records? 7
check boxes on a parameter form 3
HOw to inslert a formula into a report 7
Access 2007-, Address Labels 1
Automatically generating text entries from combo box 4
Access Mailing list problems 1
Combo box macro doesn't work 3

Top