Custom date format creates visible default value?

  • Thread starter Thread starter rakilgore
  • Start date Start date
R

rakilgore

When using a predefined date format for a field, I get null values in the
table and controls in forms as expected. But when I use a custom format in
the field definition (e.g. mm/dd), I get 12/30 as default values even though
the default value field is blank.

Why is this and what is the suggested workaround? Setting the default value
to null did not work.
 
Solved. The field was inadvertently set to be yes/no so it had been given a
default value of 0 - even though I changed it to a custom date format, the
damage was done. If only there was an easy way to get rid of all those 0's.
 
Back
Top