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 / Macros / June 2004

Tip: Looking for answers? Try searching our database.

input mask for Date/Time

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jrlh - 24 Jun 2004 18:21 GMT
I need to set up an input mask for a Date/Time data type
such that it will accept a year only if the month and day
are not available (e.g., __/__/1990).  I've tried using
the 99/99/0000 input mask, but it will not accept spaces
for the month and year.  If I use a Text data type with a
99/99/0000 input mask, then it will accept spaces but I
lose the ability to limit the month between 01 and 12, and
the day between 01 and 31.  Do you have any suggestions?  
I'm at a loss!

Thanks!

Jennifer
Steve Schapel - 24 Jun 2004 18:47 GMT
Jennifer

It is not possible to enter a date without all components: day, month,
and year.

Signature

Steve Schapel, Microsoft Access MVP

> I need to set up an input mask for a Date/Time data type
> such that it will accept a year only if the month and day
[quoted text clipped - 9 lines]
>
> Jennifer
 
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.