I tried to copy and paste it to another new table and it did the same thing.
For the other question it has a lot of data in it like 40790 records. i was thinking about create a new field programmatically, transfer all the data from the old field into it but i don't know how to get to that...