display records

[bezaman]

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?

[brucevde]

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

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