Make a text box return blank if

  • Thread starter Thread starter Bob
  • Start date Start date
B

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 said:
="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.
Click to expand...
Brilliant thanks Rick :)
 
Back
Top