I have the Default Date set in the property sheet as 10/1/2014 but it shows up in the field as 12/30/1899. Do you know why this would be and how I can correct it?
Date Default
Competent Performer
Windows XP 
Access 2010 64bit
I have the Default Date set in the property sheet as 10/1/2014 but it shows up in the field as 12/30/1899. Do you know why this would be and how I can correct it?
Competent Performer
Windows XP Access 2010 64bit
Never mind I entered it as =#10/1/2014# and it fixed it.
Who is John Galt?
Windows XP Access 2007
FYI, the # tell Access you're giving it a date. Otherwise it assumes it's a number, 10 divided by 1 divided by 2014. which is a bit after midnight on that date.
Default Calculated Date Value
Name & Date by Default
Forms Default Date
Posting Permissions
Reply With Quote