>There are 95 fields with a total length of 1048. Maximum field length 50 chars. Character, numeric, date, logical and one memo
>John

This problem could be in Numeric fields only. Write a loop to gather one field in a time until you find a problematic field. Or you can examine the record. The field, which is filled with either **** or left blank, should be a culprit.