>>I have a table with address fields (split into 5 fields)
>>I have a formula that looks something like this:
>>
>>IIF(addr_1=space(30),"",addr_1+", ")+IIF(addr_2=space(30),"",addr_2+", ")...
>>
>>which I have found to work on other occasions. However in this instance it seems to be failing, it is only displaying first lines of adresses, and in some instances, only the first few characters. Can anyone shed light on why this might be happening and suggest a way to stop it?
>>
>>Ta
>>Sha
>
>You might try ALLTrimming the fields... maybe they have leading or trailing spaces.
>
>HTH
Are you sure, that addr_1 is Character 30 field and addr_2 is Character 30?
If they are less or more than 30 chars, this comparisson would not give you the correct result.
If it's not broken, fix it until it is.
My Blog