>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?

You can use a Valid of a textbox to perform validation. RETURN 0 will keep focus on the textbox.