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 form.Any suggestions?Thanks