Results 1 to 2 of 2
  1. #1
    Kris is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    2

    Validation at form level


    Can someone tell me why this wont work please?

    Between DateAdd("yyyy",-60,Date()) And DateAdd("yyyy",-20,Date())

    It will allow the two dates to be entered but nothing either side

    eg

    28/June/1951 is OK

    27/June/1951 is not OK

    25/June/1951 is not OK

  2. #2
    Kris is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    2
    Sorry, see red below

    Can someone tell me why this wont work please?

    Between DateAdd("yyyy",-60,Date()) And DateAdd("yyyy",-20,Date())

    It will allow the two dates to be entered but nothing either side

    eg

    28/June/1951 is OK

    27/June/1951 is not OK

    30/June/1951 is not OK

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

Similar Threads

  1. BUG! Field level date validation
    By buj in forum Forms
    Replies: 0
    Last Post: 09-16-2010, 08:23 PM
  2. Form level mouseup event not firing
    By Philhoop in forum Forms
    Replies: 3
    Last Post: 07-22-2010, 09:41 AM
  3. Form Field Validation
    By dhav79 in forum Forms
    Replies: 3
    Last Post: 06-03-2010, 11:31 AM
  4. Multi Level Form
    By bkelly in forum Access
    Replies: 2
    Last Post: 08-28-2009, 11:15 AM
  5. Field Level Date validation
    By fadone in forum Forms
    Replies: 1
    Last Post: 12-09-2005, 10:23 PM

Tags for this Thread

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