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. 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:
    495
    J. Thomas Coons
    Sep 25, 2003
  2. Betty

    validation rule for text field

    Betty, Mar 20, 2005, in forum: Microsoft Access Database Table Design
    Replies:
    1
    Views:
    505
    John Vinson
    Mar 20, 2005
  3. 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:
    275
    Brad Pears
    Apr 5, 2006
  4. Guest

    Date field validation rule?

    Guest, May 24, 2006, in forum: Microsoft Access Database Table Design
    Replies:
    2
    Views:
    284
    Guest
    May 24, 2006
  5. 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:
    289
    Guest
    May 31, 2007
Loading...

Share This Page