Concatenation problem

[AnnPhil]

How do i get this concatenated field to NOT leave a blank line if the Address2 field is empty?


=[ClientName] & "
" & [Clients.Address1] & "
" & [Clients.Address2] & "
" & [Clients.Town]

 

[Fizzio]

Use an if...then statement to check in code if the field is blank then generate the string dynamically.

 

[pono1]

Or work with the iif function in a textbox...

=IIf(IsNull([clients.address2]),[clientname] & " " & [clients.address1] & " " & [clients.town],[clientname] & " " & [clients.address1] & " " & [clients.address2] & " " & [clients.town])

Regards,
Tim

 

[BLeslie88]

If all else fails.....

You could use the nz([field], " ") function... I always use it as a last resort to assign values where there is nothing or NULL....

regards,