View Single Post
  #2 (permalink)  
Old June 16th, 2005, 09:13 AM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

If the Date column is Text, then you can use an input mask and Access will run its own validation rules.

You can also program validation rules on a Date column.

I am not sure how I would approach validating existing records. I could write a brute force routine that would do it, but I am sure some of the posters here will have more elegant solutions.


mmcdonal
Reply With Quote