If is null show me 0

[Mark1982]

what is the formula? if my value is empty cell show me 0 or equal to 0.
i am working in the form design. what is the formula and where to add the formula?

 

[plog]

The Nz function (https://www.techonthenet.com/access/functions/advanced/nz.php)

You put it in the control source of where you want to show

 

[arnelgp]

You may also use the Format property of the text box:

0:\-0;0;0

 

[Mark1982]

Dear Arnel,

I try this formula 0:-0;0 in propert format but its not giving me the result.

 

[isladogs]

Using a format 0;0;0;0 works for me using a number field textbox.
So does =Nz(fieldname,0) as the control source.

 

[arnelgp]

You missed one 0.

 

[Gasman]

Dear Arnel,

I try this formula 0:-0;0 in propert format but its not giving me the result.

That is not even what arnelgp posted?