Return "No Records" if Count([Field])=0

[jaaret]

I'm using the Count function in the header of a continuous records sub-form to return the number of records. This works when there are records in the sub-form, however, if I go to a record in the main form and there aren't any records yet in the sub-form the field is displaying a blank rather than 0 (zero). I've tried the NZ and DCount functions but still am getting a blank. How do I get the field to display, "Zero Records" if there no records in the sub-form?

 

[jaaret]

I came up with a workaround. I added a field to the main form that evaluates the field with Count([field]) on the sub-form using the IsNumeric function:

=IIf(IsNumeric([subform].[Form]![field])=0,"No Records",[subform].[Form]![field] & " Records")

This works for me.