I'm trying to set up a database for a school project. My instructor loves to go into random fields and type garbage in an input field and see if the system stops him (ie "3401" for the "Name" field).
I've tried 15 different validation rules all based on NOT <0, NOT >0, NOT = 0. Nothing works. I would think just setting the field to "Text" in Design view would do it, but I guess that makes too much sense.
Does anyone know how to do this? This is the last bit of table formatting I have to do before I do the relationships (which I know how to do), add in my records (through forms), set up forms, queries, etc.
HELP A NOOB OUT!!!PLZ!!!!