how to use validation rule in ms access
Posted on 2000-01-09
I am working on an ms access project in vb-6 on a windows 95 platform.I am using dbgrid control to view my database on the fronthand (vb).Database has the following field
0001,0002,0003,0004.The user has the capability to add more records when he requires,but there is a range of (0001--0100)
he cannot add any number except from these.
I have set dbgrid1.addnew=true,dbgrid.delete=true.what I want is to have some validation rule which checks whether the data entered is in the record or not,if not it should give an error message.I tried giving input>0001 and input <0100 in validation rule but it gives a command "type mismatch" for any value changed