Printing Addresses

[Nigel]

I have a database containing individual fields for people's addresses:
Address1, address2, Address3, Town, County, PostCode. Some have 2 lines to
their address line and some 3. How can I print an address on a report but not
have a space where address3 would be if it is null?

Thanks

 

[fredg]

I have a database containing individual fields for people's addresses:
Address1, address2, Address3, Town, County, PostCode. Some have 2 lines to
their address line and some 3. How can I print an address on a report but not
have a space where address3 would be if it is null?

Thanks

= ([Address1]+Chr(13)+Chr(10)) & ([Address2]+Chr(13)+Chr(10)) &
[Address3]

The above will print each Address on a separate line. If one address
line is missing, there will be no blank line for it.

 

[Nigel]

Many thanks

I have a database containing individual fields for people's addresses:
Address1, address2, Address3, Town, County, PostCode. Some have 2 lines to
their address line and some 3. How can I print an address on a report but not
have a space where address3 would be if it is null?

Thanks

= ([Address1]+Chr(13)+Chr(10)) & ([Address2]+Chr(13)+Chr(10)) &
[Address3]

The above will print each Address on a separate line. If one address
line is missing, there will be no blank line for it.