Hi Magus069.Thanks for your reply.I tried this but I'm still getting a blank value.If one of the fields are blank, I still need whatever is on the otherfield.E.g.:Line 1 is address line 1Line 2 is address line 2 If address line 2 is blank, I still need the address line 1 field to bepopulated on my f...