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

 

[Rick Brandt]

="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

="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.

 

[Mushroom]

For starters, your dLookup is missing the "where.." clause.

Start by looking here.
http://allenbrowne.com/casu-07.html

 

[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