Hi Nigel,

Hmmm.... I presume you added the missing paranthesis that I missed at
the end. Try this instead:

=IIf(IsError(Count(*)), "No Data", Count(*))

Clifford Bass

Nigel wrote:
Hi Clifford

I tried inputting your suggestion into the unbound box but when I get a
record with no data I still get thge #Error message.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/201001/1