Print Customer address if no ShipTo ID

[Aerowolf]

I have a customers table and a shipto table.

On a report that prints the shipper, I have the Customer info print on the left side and the shipto info print on the right side.

What I want is that if there is no shipto id selected, i want the Customer info printed on the right side as well as on the left side (ie. shipto info defaults to customer info if no separate shipto id exists).

Thanks

Edwin

 

[dhookom]

You can use text boxes with the Control Source set to:
=Nz([ShipAddress],[CustAddress])
Substitute your field names. Also, make sure the name of the text box is not also the name of a field.

Duane
MS Access MVP