display records

I have a formula field that looks like this:

'"' & {tblMailList.F1} & '"' & "," & '"' & {tblMailList.F2} & '"'

If tblMailList.F2 is null then the record is not displayed. How do I get around this?

That does not appear to be a valid formula. Regardless, use an If statement.

Code:

---

If Not (IsNull(tblMailList.F1) Or IsNull({tblMailList.F2})) Then
  '"' & {tblMailList.F1} & '"' & "," & '"' & {tblMailList.F2} & '"'
End If

---