P PoisonedDoxy Guest May 7, 2006 #1 hi can anyone tell me all the different types of data checks that can be used in database tables such as field length check and range check thank you
hi can anyone tell me all the different types of data checks that can be used in database tables such as field length check and range check thank you
D Dwight Registered User. Local time Today, 21:15 Joined Mar 17, 2003 Messages 168 May 8, 2006 #2 It is my understanding that the surest way to perform data validation is to use VBA code on the form where the data is entered into the table. By placing code on the form's Before Update event you prevent the user from inputting incorrect and/or incomplete data. So I suggest looking into this for your particular needs. Dwight
It is my understanding that the surest way to perform data validation is to use VBA code on the form where the data is entered into the table. By placing code on the form's Before Update event you prevent the user from inputting incorrect and/or incomplete data. So I suggest looking into this for your particular needs. Dwight
