Thanks to a few in the general forum, I have successfully used
Data-Validation. I have since then decided that the best way to have data
entered is by using a form as there are thousands of records.

My questions a 1. How can I enforce a unique entry into a textbox? 2.
How can I enforce a date being entered (in mm/dd/yy format with the "/"). 3.
How can I enforce a phone number being entered ie 10 digits with no dashes.
I have another entry for a serial number which would be x amount of
characters, but I think that would be the same as the phone number scenario.

Thanks in advance,
Richard