[AccessD] Re: Date data entry

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




More information about the AccessD mailing list