Make a text box return blank if

[Bob]

="If Unclaimed Return To: " & DLookUp("ReturnAddress","tblCompanyInfo")

If there is no data in ("ReturnAddress","tblCompanyInfo") then the text box
will be blank, Thanks in Advance Bob







..........Jenny Vance

 

[Bob]

="If Unclaimed Return To: " + DLookUp("ReturnAddress","tblCompanyInfo")

The + symbol will make the whole thing evaluate to Null if any part of it
does. In cases where you want that behaviour you can use it instead of
the & symbol.

Brilliant thanks Rick