Concatinating Address Lines

[sush]

Hi,

I have 3 address lines, town , county and a postcode,

On a report i would like to print this information but as these are seperate fields, if any information in any of the lines is not entered a gap is left before the next field.

Is there a way to stop this? i.e by having all the address information concatinated into one field which will expand and surpress depending on whether all or some address information is used??


Thanks in Advance

 

[Phillip]

Add a column to the underlying query; Something like this:

AllThree: Iif(IsNull([town]),"",[town] & " ") & Iif(IsNull([county]),"",[county] & " ") & [postcode]

Then just create one (wide enough) text box on your report and assign its control source to your new field ("AllThree").

 

[sush]

Hi,

Thanks for the advice i tried this and it seems to work, but it puts everything on one line and not under each line.

Any ideas

thanks in advance