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.