How do I format postal addresses in an access report.

[Guest]

We need to print letters from access, and are using an access report as the
output.

Some postal addresses have house names and street numbers and others only
have street numbers, also some have names but no street numbers. The print
out we have has all sorts of spaces due to this.

How do we print a neat evenly spaced address given the above?

 

[Rick B]

Try using something like the following in an unbound text box.....

[StreetNumber] & (" " + [StreetName]) & (" " + [HouseNumber])

This will print the StreetNumber (replace with your field name) it will then
print a space and the street name IF there is a street name. It will then
print a space and the house number IF there is a house number.

You may have to modify to meet your needs, but I think that will get you
going.