[AccessD] Entering an ISO date with input mask and full validation

[Jim Lawrence]

Hi Gustav:

Impressive piece of work...I suspect it is years in the making and years in the proofing. (My favourite date format...works numerically, alphabetically and date wise.) 

I will save this piece of code for future reference.

Jim

----- Original Message -----
From: "Gustav Brock" <gustav at cactus.dk>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Friday, January 1, 2016 10:47:19 AM
Subject: Re: [AccessD] Entering an ISO date with input mask and full validation

Happy New Year to all.

I've made a "sister" demo of the time entry textbox - now for a date entry in the ISO yyyy-mm-dd format.

Again, a demo is included, ready to download and run:

    http://rdsrc.us/5xabOS

The error catching is somewhat different, but the inputmask plays a big role.

/gustav

________________________________________
Fra: AccessD <accessd-bounces at databaseadvisors.com> på vegne af Gustav Brock <gustav at cactus.dk>
Sendt: 11. december 2015 14:07
Til: Access Developers discussion and problem solving
Emne: [AccessD] Entering 24-hour time with input mask and full validation

Hi all

Years ago - in Access 2.0 - I made a form with a bound textbox for 24-hour fool-proof input.
Recently, I had this need again, so I brushed it up for A2013/2016 and wrote down the thoughts behind as a note on Experts-Exchange.

Here it is, including a demo ready to run:

    http://rdsrc.us/Le82yJ

It makes heavy use of an inputmask, the textbox's KeyPress event, and the form's Error event.

/gustav
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com