|
View Full Version : Concatenation problem AnnPhil 08-21-2002, 09:02 PM 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 08-22-2002, 12:44 AM Use an if...then statement to check in code if the field is blank then generate the string dynamically. pono1 08-22-2002, 01:02 AM 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 08-22-2002, 10:48 AM 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, |