>>>I have several txtFlds on a form that the controlsource fields are tied to numeric fields. When I create a new record and display the form the fields show blank instead of zeros.
>>>
>>>I set the txtFld.InputMask = 9999.9, txtFld.Format = K, and
>>>txt.FldValue = 0.0 The controlsource = tbl.fldname
>>>
>>>What am I missing?
>>If using buffering, new records have .null. instead of 0. You could try "set nulldisplay" but it would work for text too.
>>Cetin
>
>if fields accept null values, right?
But Dave wouldn't that be important when tableupdate() ? I mean if table doesn't accept nulls, I can still append blank, values are null at the moment, must be filled before update. Isn't this true ?
Cetin