[AccessD] Detecting Date Errors

Bud,

    If you wish to ensure that only valid entries are made in day and month parts (so that there is no need for auto-correction forced by the system), my sample db named  InputMaskDateValidation might be of interest to you. It is available at Rogers Access Library. Link -
http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=45

    The sample is in access 2000 file format and brief description is given below, for ready reference.

Best wishes,
A.D. Tejpal
------------

  ----- Original Message ----- 
  From: Bud Goss 
  To: Access Group 
  Sent: Thursday, March 12, 2009 21:46
  Subject: [AccessD] Detecting Date Errors


  I have a system with forms that read various tables with a date fields.

  The forms in this system have a format of Short Date and an Input Mask of 99/99/0000;0;_

  If I enter 30/30/2009 in these forms, the entry is rejected with an error message.

  But if I enter 30/7/2009, the system converts this to 7/30/2009 with any warning message.

  Is there any reasonable way, to cause this second entry to be detected and rejected as an error?