Re: User enter date like "12/05/345

angela wrote:
Is there any way to stop the user from entering the date in the above
format? i have tried using the validation rule, default, and inputmask but
the user is still able to enter the date "12/05/345" (where 345 is any random
number) and the validation is not checking it.

"As soon as you idiot-proof something, the world invents a better idiot!"

Dates are probably one of the worst possible, from a raw data input perspective.

A lot of folks simply give up, and use a calendar-type control instead.

Only other choice is to errortrap after an attempted CDate, then check whether a
valid result falls within the acceptable range, and finally hope the user has the
same conception of what order the numbers need be entered in. (ie, what's
02-03-04?)
--
..NET: It's About Trust!
http://vfred.mvps.org


.

Relevant Pages

  • RE: Number Field Automatically Rounding Decimals
    ... I want the number to the nearest hundreth (second ... How do I turn off the rounding get the table to ... Format - Fixed (I have tried various formats that did not change the ... Validation Rule - ...
    (microsoft.public.access.reports)
  • RE: Multiple Validation Expressions
    ... Storing leading zeros is not a big concern for me unless for some reason it ... Do you have information on how to ensure that a specific a number of digits ... I like using the validation rule for this b/c it will alert ... someone immediately when something isn't entered in an acceptable format. ...
    (microsoft.public.access.gettingstarted)
  • Re: Date validation not working
    ... If the field is text data type, ... because your expression is comparing a text ... The format on the table is text, ... >> validation rule? ...
    (microsoft.public.access.formscoding)
  • Re: Multiple Validation Expressions
    ... "John Spencer" wrote: ... behind it saying the data violates the validation rule. ... Do you have information on how to ensure that a specific a number of digits ... someone immediately when something isn't entered in an acceptable format. ...
    (microsoft.public.access.gettingstarted)
  • Re: question about running a certain query in access
    ... smartly created that field as a Text, and set a validation rule on ... Microsoft Access MVP ... I have a database of over 10,000 part numbers that are six characters ... long and should be in this format: ...
    (microsoft.public.access.queries)