Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date Validate (2000)

    Hi,

    Is anyone know some date vlidate code that better than use input mask?

    Thanks

    Regards

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Date Validate (2000)

    What exactly do you mean? An input mask simply requires input in a particular format, it doesn't do any validation other than making sure the value is a real date.
    Charlotte

  3. #3
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Validate (2000)

    I am sorry for unclear information. I am looking some code can replace input mast to requires input in a date format.

    Thanks

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Date Validate (2000)

    The input mask does require input in a date format. Are you trying to check the date to see if it meets certain rules? If so, you would do that in the BeforeUpdate event of the date control on your form. That allows you to cancel the update if the entered value doesn't meet requirements and forces the user to stay in the date control or use ESC to cancel the input.
    Charlotte

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Date Validate (2000)

    If you set the Format property of a text box to one of the date formats (either a built-in format such as Medium Date or a custom format such as dddd mmmm d, yyyy), Access will accept only valid dates as input (but they don't need to be entered in any specific format).

  6. #6
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Validate (2000)

    Thanks, Hans.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •