DCount in calculated text box returning NOTHING

[Shaft]

I am trying to use DCount to count the number of record that = 0 for field checklistitem_1 in table 'Data Input'.

I firstly tried =DCount("[ChecklistItem_1]","Data Input","[ChecklistItem_1] = 0") but this returned nothing.

So I tried =DCount("*","Data Input") just to see if I could get something back and still nothing.

I double check the names are correct, dropping the quotation marks different combination of brackets and nothing every time.

Please help me

 

[Shaft]

Very strange Access behaviour. I shut down access completly restarted it and it works now.

I have had this happen before has anybody got an explaination?