access 2007,
In my report I have a unbound text box that the user will use to enter the file date which could be earlier than the current day. In my control source I am using the code below:
=[enter date as mm/dd/yyyy]
This works fine and appears on the report when run and printed. What I would like to do is set some kind of data validation so they can not input the date any other way except for the short date format above. Right now it will accept anything you enter.
Any ideas?
Thanks,
Bruce D.