Results 1 to 3 of 3
  1. #1
    oediaz is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2010
    Posts
    2

    Date error checking

    I have a textbox formatted to Short Date. If a user accidently types a date of 3/1/200 for example, it accepts the entry as March, 1st of the year 200 - not the desired result. How can I catch this error, since it doesn't meet the mm/dd/yyyy format of the text box?



    Thanks for any help on this.

  2. #2
    c_smithwick is offline Underpaid Programmer
    Windows 7 Access 2003
    Join Date
    Jan 2010
    Location
    Lakeside, CA
    Posts
    49
    Set the input mask property for the text box to short date as well, and if the user enters the date in the wrong format, he/she will get a warning and will have to correct the entry or escape and cancel in order to proceed.

  3. #3
    oediaz is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2010
    Posts
    2
    Thanks for your reply. I tried the input mask technique but what I didn't like was that when a user clicks into the the text box the cursor appears randomly within the masked area and if the user just starts typing in a date the date parts may not be located in the correct area - looks a little messy too.

    Is there another way I can progammatically catch any date entry errors?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Checking if files exists
    By geoffishere in forum Access
    Replies: 1
    Last Post: 02-09-2010, 01:32 PM
  2. Current Date Error
    By McFly in forum Database Design
    Replies: 4
    Last Post: 02-04-2010, 09:08 AM
  3. Checking for Value in Query
    By jgelpi in forum Access
    Replies: 1
    Last Post: 06-24-2009, 04:57 PM
  4. Date error on my forms
    By elbob62 in forum Access
    Replies: 1
    Last Post: 12-05-2008, 05:35 PM
  5. Checking a record in a table
    By widstje in forum Programming
    Replies: 4
    Last Post: 11-07-2007, 11:28 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums