How to make a bounded control default to 0

[George]

Good Day All,

I have a field "customer Deposit" in a table "Customers". The default value in the table is set to the number 0. However when this field is bounded to a control on a form the field on the form show up blank. In the property sheet of the form I also set the default value as 0 but this does not help. I also use the nz([customer Deposit], 0) and this does not work either.

can anyone help me to get a zero value to display visibly in this form field?

[ranman256]

this is odd because setting the table defaultvalue =0 and/or form field.defaultvalue = 0 always works.
you could also try,
in the form event ON CURRENT
add this code:

sub Form_onCurrent()
  if IsNull(txtBox) then txtBox= 0
end sub

[CJ_London]

to be clear, the default will only work for new records - existing records with null values will not display 0 (although you can use the format property to display 0 instead of nothing) - property would be perhaps

#;;;\0

change the # to be whatever format you would normally display