Text Field Validation Rule for Date
in [Tables]
|
Prev: Access 2007 FE/SQL 2005 BE - Fatal errors occurring
Next: need good database structure for tracking counter state
From: shm135 on 3 May 2010 17:30 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
From: KARL DEWEY on 3 May 2010 19:08
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 > . > |