How can I make an Access form count cells in which the inputed word is different from the default?

Question

Or different from what I want it to be? I want one field to display this number.

Answer 1

Suppose the cells you want to count are in a field called ThisField in a table called tblX, and the default value for this field is 'DefaultWord'

Then you can use the DCount function:

=DCount("[ThisField]" , "tblX" , "[ThisField] <> ' " & "DefaultWord" & " ' ")

And enter it into the Control Source property of the text box you are using to display this number.

Eliminate the spaces between the " and ' I used to make the expression more readable.