[AccessD] Date validation in the form

Hahahaha, that gives me hope as I do this sort of thing frequently enough!! :)



-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, 13 March 2012 12:47 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Date validation in the form

LOL, well that is embarrassing! The test works just fine.  My default value for this particular date text box was a month out and I changed the *day* part to 10 (today is the 12th).  Since I didn't change the *month* portion the date was still in the future.

John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

On 3/12/2012 9:27 AM, jwcolby wrote:
> I set a validation rule to >=Date() and a validation text to explain 
> if they break the rule. I opened the form and set the date to 
> yesterday and the rule was not enforced, i.e. it did not complain or 
> refuse to allow me to perform the update. I expected it to complain as 
> I moved out of the control, or at the least when I tried to move off the record, but it did not complain in either case, and it did perform the save.
>
> Do we know whether this is a "DAO behavior", i.e. that maybe using 
> forms bound to ADO recordsets do not perform this checking?
>

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com