Counting in reports

[Webmaster@worksnotfun.com]

I have a textbox called recordcount, control source =1, and running sum is set to overgroup. In the report footer I have a text box which is set to count the number. There is no query. The control Source is =([recordcount]). This works as long as there is data, but as soon as there is no data, it reports 1. I've played with both the Nz & Iff. I.e. =IIf(Nz([RecordCount])="",0,Count([RecordCount])), now the report can't find Recordcount.
Teresa

 

[Capilano]

Try =IIf(IsNull([RecordCount]),0,Count([RecordCount]))

Pat

 

[Webmaster@worksnotfun.com]

It looks like it would work, but it doesn't; it can't find recordcount

 

[Rich]

Iif (Not IsNumeric([RecordCount]),0,[RecordCount]))

 

[Webmaster@worksnotfun.com]

That didn't work but adding an event to the report, NO data did.

Private Sub Report_NoData(Cancel As Integer)
MsgBox "There aren't any records to display, try another date!"
DoCmd.Close acForm, "Dock Audit Discrepancy Report"
Cancel = True

End Sub