Re: Boolean value cells default to "checked" at every new row

Am Samstag, den 05.01.2008, 16:54 -0500 schrieb Dinbandhu:
> Hello,
> 
> I have an address list data base with around 20 columns of boolean type.
> Every time I start a new row, all the boolean values are appearing as
> "checked". That means I have to go across and uncheck all those boolean
> values every time I initiate a new row. This should not be. I have other
> Base tables with boolean values, and that does not happen. Why is it
> happening with my address list? Is there some setting which needs to be
> changed? Whatever the setting is, it is affecting ALL the boolean value
> columns. What needs to be done to fix this?

Funny behaviour ... wouldn't it be enough to give all columns a default
value?

I'm not sure currently if this is possible on the databases side (when
creating the table - mostly yes) but you can at least give a default of
false (or 0 or "unchecked") when creating the form showing this data.

HTH,
Marc