How do you  check length of a field on access?
 SELECT column_name as 'Column Name', data_type as 'Data Type', character_maximum_length as 'Max Length' FROM information_schema,columns WHERE table_name = 'tblUsers'. 