>I have a 6(c) field for stock tickercode with over 9000 entries.
>Some how only the first letter of the 6 char now displays and I can not reason why.
> I did a view to see if all info was displayed, and it was. So I did a query, got all the info displayed as before, copied it to a new table, got all the info, saved it(whew),copied it to my zip, then re-entered it into the original table and got only the first letter of the 6(c) field again.
> At no time was I ever in the table designer where I could have changed any of the structure.

Any LTRIM, RTRIM, LEFT or RIGHT functions involded?

Is your table structure still the same?

Wasn't lost until you recovered the data from the new table?