Yep, that fixed it. Thanks.


>The only time I have seen this error is with calculated fields. The problem is that the first time you use the view, the field length (if it is a character) is set. If requery() and the value of that field is a different length then you get this error. The answer (for me) has been to absolutely fix the length of the field. Use PADR() PADL() LEFT(ALLTRIM(x)+SPACE(y),z) or some function like that to eleminate the posibility of the field being different when you requery and get a different record. You need to adjust this solution for your specific calculated field.