Date Validate (2000)

Topic

New Reply

Hi,

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

Thanks

Regards

Reply | Quote

Replies

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.

Reply | Quote

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

Thanks

Reply | Quote

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.

Reply | Quote

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).

Reply | Quote

Thanks, Hans.

Reply | Quote