It could be making multiple rows but the ISNULL statement should still function.
That being said I have had problems with ISNULL and it having to always be he first part of every statement.
Does it work for either if you only use the isnull condition on each of these fields one at a time?
if isnull({tblWilliamsProjects.Project}) then "Hide" else "Show"
if isnull({tblWilliamsGrantExpenditures.ID-sbfrmWillamsGrantExpenditures}) then "Hide" else "Show"
Edited by DBlank - 01 Dec 2009 at 1:53pm