Printing Addresses

N

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
 
F

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

Nigel

Many thanks

fredg said:
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.
 

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

Top