Iif when printing address

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

Guest

I have a database that has two different address fields for some customers.
All customers have the main address field and some customers use a Shipping
address. When I am printing an invoice I would like to print the Shipping
address if there is one and if there isn't to print the main address. I
tried using IIf(IsNull([ShipAddress1]),[Address_1],[ShipAddress1]) but am
getting #Error when I print. How would I go about doing this?

Thanks for any help or suggestions.

Arica
 
You might have just forgotten the "=" to the left of IIf(). You can use Nz()
which is simpler:
=Nz([ShipAddress1],[Address_1])

The name of your text box can't be the name of a field in your report's
record source.
 
Back
Top