Zeros Everywhere!

[Guest]

My form has a good deal of text fields of type "number" or "currency" that
have a tendancy to set themselves all equal to zero (0), even though their
default values are set to null.

Maybe in the grand scheme of things a Null is mathematically equal to a
Zero, but for my purposes, being able to have a number field's default value
equal to Null (and actually work correctly) would be much better.

Any ideas?

Thanks!

Nick

 

[Albert D.Kallal]

There is two places to check.

First, check the table (in design mode) for the default value of 0. If it is
set, then simply remove the 0, and the field will default to null.

You also have to check the default in the control on the particular form, as
it too can have a default value set for the control.

 

[Guest]

Check the Default Value property of the field in the table. It may be the
culprit.

 

[Guest]

That was it! The controls had default values of zero! Guess the control
defaults trump the form field defaults.

Thanks!

Nick