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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
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:
    1,185
    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:
    346
  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:
    761
    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:
    642
    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:
    2,472
    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:
    717
    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:
    563
    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:
    495
    Guest
    May 31, 2007
Loading...