Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / December 2007

Tip: Looking for answers? Try searching our database.

Date calculations

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dave - 18 Dec 2007 16:59 GMT
is there any way I can get 00/00/0000 to be used as a default value in a
date field (Table and form).

Thanks
dave
Rick Brandt - 18 Dec 2007 17:05 GMT
> is there any way I can get 00/00/0000 to be used as a default value
> in a date field (Table and form).
>
> Thanks
> dave

In a DateTime field, no.  What's wrong with Null for the default?

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com

John W. Vinson - 18 Dec 2007 18:32 GMT
>is there any way I can get 00/00/0000 to be used as a default value in a
>date field (Table and form).
>
>Thanks
>dave

No, because that's not a valid date. Why would you WANT it?

            John W. Vinson [MVP]
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.