Robert L. Stewart
rl_stewart at highstream.net
Mon Oct 6 12:54:24 CDT 2003
John,
Separate the data entry into 3 text boxes
enter the day, month then year with the
year defaulted to DATEPART("yyyy",date()).
That is the simplest.
Another way is to check the length of the
string for the date on keyup and fill
in the year after 4 keystrokes.
Robert
At 12:00 PM 10/6/2003 -0500, you wrote:
>From: "John Colby" <jcolby at colbyconsulting.com>
>To: "AccessD" <AccessD at databaseadvisors.com>
>Sent: Monday, October 06, 2003 7:44 AM
>Subject: [AccessD] Date data entry
>
>
> > I have a specific client that LOVES the input masks for dates. I don't
> > understand this as I personally hate them, but...
> >
> > What they want is to have something like that but which "assumes current
> > year", i.e. all they have to enter is the ddmm and the rest (the year) is
> > filled in.
> >
> > Does anyone do this? Know how to do this?
> >
> > John W. Colby