[AccessD] Gaps in Address Query

To all, 

I posted this a couple of days ago, and had a few responses to help me along the way (Thanks Very Much), however I have the following inside a query :

AddressDetail: [Name] & Chr(13) & Chr(10)+IIf(IsNull([addrs1]),"",[addrs1]+Chr(13)+Chr(10))+IIf(IsNull([addrs2]),"",[addrs2]+Chr(13)+Chr(10))+IIf(IsNull([town]),"",[town]+Chr(13)+Chr(10))+IIf(IsNull([county]),"",[county]+Chr(13)+Chr(10))+[postcode]

Basically, if a part of the address line is null then I want to shift the address up, if not put the field in and move onto the next line.  The query runs ok, however there are still line gaps in the address where the field is blank.  I have tried various combinations including changing the + to & and only using + for the chr(13)+chr(10), and the query still comes out the same.

Anyone any ideas as to why this is happening ?

Paul Hartland

__________________________________________________________________________
Join Freeserve http://www.freeserve.com/time/

Winner of the 2003 Internet Service Providers' Association awards for Best Unmetered ISP and Best Consumer Application.