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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Default Value =Date$() in UK Date Format 5
Forcing a date entry format of dd/mm/yyyy 1
displaying dates in UK format 10
how to set the Default Value of a Control Box to a Lookup Table 0
Date field not stay in same format 1
dafault value for date not working with Date() but Now() is workin 3
Default value 3
Date in unbound textbox 3

Back
Top