Text Field Validation Rule for Date

Discussion in 'Microsoft Access Database Table Design' started by shm135, May 3, 2010.

  1. shm135

    shm135 Guest

    Hi,

    I have a RESPONSE field on my table. This field is set up as a text
    field (I do not want to change it due to specific requirements)-
    however, I'd like to set up a validation rule to determine whether or
    not it is a valid date: mm/dd/yyyy. What should I input in the
    validation rule?

    Thanks
     
    shm135, May 3, 2010
    #1
    1. Advertisements

  2. shm135

    KARL DEWEY Guest

    I do not think it is possible at table level but in your data entry form us
    AfterUpdate event and IsDate function.

    --
    Build a little, test a little.


    "shm135" wrote:

    > Hi,
    >
    > I have a RESPONSE field on my table. This field is set up as a text
    > field (I do not want to change it due to specific requirements)-
    > however, I'd like to set up a validation rule to determine whether or
    > not it is a valid date: mm/dd/yyyy. What should I input in the
    > validation rule?
    >
    > Thanks
    > .
    >
     
    KARL DEWEY, May 4, 2010
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Mohammed Ali

    Validation rule in a numeric field of complex expression

    Mohammed Ali, Sep 19, 2003, in forum: Microsoft Access Database Table Design
    Replies:
    1
    Views:
    990
    Douglas J. Steele
    Sep 19, 2003
  2. Mohammed Ali

    Validation rule in field properties

    Mohammed Ali, Sep 19, 2003, in forum: Microsoft Access Database Table Design
    Replies:
    1
    Views:
    257
  3. J. Thomas Coons

    validation rule violations when there are no validation rules!

    J. Thomas Coons, Sep 25, 2003, in forum: Microsoft Access Database Table Design
    Replies:
    0
    Views:
    611
    J. Thomas Coons
    Sep 25, 2003
  4. Betty

    validation rule for text field

    Betty, Mar 20, 2005, in forum: Microsoft Access Database Table Design
    Replies:
    1
    Views:
    565
    John Vinson
    Mar 20, 2005
  5. Guest

    validation rule based on another table's field

    Guest, May 4, 2005, in forum: Microsoft Access Database Table Design
    Replies:
    6
    Views:
    1,890
    Guest
    May 8, 2005
  6. Brad Pears

    basing a field validation rule on another field in same table...

    Brad Pears, Apr 4, 2006, in forum: Microsoft Access Database Table Design
    Replies:
    2
    Views:
    532
    Brad Pears
    Apr 5, 2006
  7. Guest

    Date field validation rule?

    Guest, May 24, 2006, in forum: Microsoft Access Database Table Design
    Replies:
    2
    Views:
    392
    Guest
    May 24, 2006
  8. Guest

    Validation Rule? IF (Field A) = (Cell Value), then Field B ok

    Guest, May 31, 2007, in forum: Microsoft Access Database Table Design
    Replies:
    2
    Views:
    392
    Guest
    May 31, 2007
Loading...