blanks in addresses

[Graham Bucknall]

I have a table with the usual add1, add2, add3, town,county, postcode.
I want a letter with the address at the top but withour blank lines if there is no add2 and add3 etc.
Does anyone have any suggestion as to how I can do this?

Many thanks

 

[spacepro]

Do a search for the IIF function.

Loads of posts recently on this.

ANdy

 

[Graham Bucknall]

Thanks for that. I have looked at some and it seems to help except I get small boxes instead of Carriage return/Line feed for the Chr(10)&Chr(13).
Any ideas?

If I use VbCrLf instead it just askes me for an input.

 

[Rich]

Posting your syntax might be helpful