I have student.dbf with fields 1.Regno (N), 2.Name(C),3. DOB(d) 4.Course(C), 5.Category(C) and I have data entry form in that I placed 1.txtregno 2.txtname 3.txtdate 4.txtcourse 5.txtcategory. Before append the record I want to validate the data.

1. The regno field is numeric data type having 5 digit, by mistakenly i have typed more than 5 digit number means the message box tell "you cant enter more than 5 digit number".

2. By mistakenly i have type string in the txtregno box means the message box tell "It is not numeric".

how to do this?