Zeros Everywhere!

T

Tatakau

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
 
A

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.
 
T

Tatakau

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

Thanks!

Nick
 
Top